[DB-SIG] Use of context managers with DB API 2
cito at online.de
Sun Nov 4 23:24:53 CET 2012
Am 04.11.2012 19:32, schrieb Michael Bayer:
> IMHO the DBAPI is a low level API that should do just one thing,
> allow rudimental functionality to a relational database with as much
> consistency as possible.
Essentially agreed, but I think it's excusable for SQLite as a
light-weight database to make an exception here so that it can be used
easily and directly from the standard lib without the need to install
any additional higher level wrapper.
To wrap everything up, as a result of our discussion, I will do the
following in the next version of PyGreSQL:
* make connections context managers for transactions
(may not be the optimal solution, but it's already established)
* make cursors self-closing context managers (evident)
* not implement shortcut functions (see above)
Is everybody happy with that?
More information about the DB-SIG