Re: Python interfaces

[Cristian Gafton <gafton(at)rpath(dot)com>]

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.