dbapiext: Proposed extensions to DBAPI

Presenter: Martin Blais <blais@furius.ca>, EWT LLC

I will present some modifications that could be made to the DBAPI-2.0 Cursor.execute() function to make writing SQL queries much easier than it currently is. In particular, the simple modifications that are proposed make it less likely for users to make mistakes that involve escaping parameters, take advantage of the dynamic typing capabilities of Python and significantly reduce the amount of code required to perform some of the common SQL query. In addition, I will demonstrate an implementation of the proposed features on top of an existing DBAPI interface (psycopg2). The simple Python module that implements the new features to work on any existing DBAPI interface is available for download.

http://furius.ca/pubcode/pub/conf/common/lib/python/dbapiext.html http://furius.ca/pubcode/pub/conf/common/lib/python/dbapiext.py.html