Re: Python interfaces

On Fri, 15 Sep 2006, D'Arcy J.M. Cain wrote:

>> I am in the process of moving development from perl to python.  Under perl,
>> there was DBI, the be-all-end-all of database interfaces.  Under python,
>> there is a plethora of options.  Is there a recommended one for postgres?  It
>> will be mainly used in a web environment, so the ability to work
>> asynchronously is not that important.  I am interested in maintaining
>> database introspection (which the DB-API 2.0 is conspicuously short on)
>> tools, as well as niceties such as automatic escape-quoting, etc, that are
>> pretty standard in perl.  Any suggestions?
>
> I maintain PyGreSQL which used to be the one shipped with PostgreSQL
> before we split it off into a separate project.  http://PyGreSQL.org/.

I maintain a further split from PyGreSQL that supports native bind 
parameters and prepared statements at:    http://cheeseshop.python.org/pypi/python-pgsql
(using bind parameters eliminates many worries about escape quoting...)

Cristian
-- 
Cristian Gafton
rPath, Inc.