[DB-SIG] autocommit support in pep-249

Michael Bayer mike_mp at zzzcomputing.com
Wed Sep 14 19:25:46 CEST 2011

On Sep 14, 2011, at 12:56 PM, Joshua D. Drake wrote:

> No. What I am saying is, the begin() is optional. If you look at my example, if PostgreSQL is in autocommit mode, the only way to start a transaction is to execute a query to start the transaction (BEGIN or START TRANSACTION). From a, "it would be nice if" perspective, I would like to have the option of using .begin() to start a transaction. That seems to jive better with proper coding.

"proper" on postgresql sure.  On Oracle, there is no BEGIN.   I like that the DBAPI tries to simplify this disconnect with a consistent, moderately coarse-grained facade rather than confusing users and burdening DBAPI authors with two ways to do it.

More information about the DB-SIG mailing list