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

Ian Bicking ianb at colorstudy.com
Wed Aug 16 20:29:30 CEST 2006


> 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.

-- 
Ian Bicking | ianb at colorstudy.com | http://blog.ianbicking.org


More information about the DB-SIG mailing list