[DB-SIG] Proposed improvements to DBAPI 2.0 Cursor.execute() method.

M.-A. Lemburg mal at egenix.com
Wed Aug 16 21:10:10 CEST 2006

Ian Bicking wrote:
>> Martin Blais wrote:
>>> I want to propose a few improvements on the DBAPI 2.0 Cursor.execute()
>>> method interface.  You can find the details of my proposed changes
>>> here:
>>> http://furius.ca/pubcode/pub/conf/common/lib/python/dbapiext.html
>>> And a pure-Python preliminary implementation of these changes that can
>>> sit on an existing DBAPI 2.0 implementation (tested with psycopg2):
>>> http://furius.ca/pubcode/pub/conf/common/lib/python/dbapiext.py
>>> (If this gets accepted IMO this preliminary hack should instead be
>>> implemented at the lower-level of the specific DBAPI implementations
>>> for performance reasons...)
> If it can be implemented as a wrapper it doesn't seem too important to 
> me.  It also doesn't seem very performance-sensitive.
> I would like to see some improvements in DB-API, but these are in the 
> area of better metadata about connections and normalizing some of the 
> stickier areas (like paramstyle), and maybe some more normalization of 
> connection instantiation.  I think the norm should be that DB-API 
> connections get wrapped if you are concerned about convenience.


> All that said, I think there's also room for more standards, but they 
> can build on the DB-API instead of extending it.


Marc-Andre Lemburg

Professional Python Services directly from the Source  (#1, Aug 16 2006)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::

More information about the DB-SIG mailing list