How Modern SQL Databases Are Changing Web Development: Part 1
I wish SQL DBs had some focus on implementing stateless protocols. Is there any reason the &quot;connection pool&quot; could not be built into the same service as the SQL database, and start a move to an RPC protocol instead of stateful protocol?<p>So instead of &quot;set xact_abort on&quot; being a command setting one of a hundred possible 100 stateful connection flags, such flags would be part of every network roundtrip (as it is with HTTP).<p>Of course long lived DB transactions, temporary connection scoped tables, etc would need to be adjusted a bit in approach. But a shift towards SQL over RPC is certainly not impossible.<p>And long lived, client managed database transactions are worse performance wise than doing the transaction in one roundtrip; SQL is powerful enough that stored procedure-style transactions with parameter tables can do anything -- and for cases they cannot, optimistic concurrency control should usually be chosen instead anyway.<p>The cases where a long lived&#x2F;client managed SQL transaction is NEEDED is rather seldom.