Which Python module for PostgreSQL?

David M. Cook davecook at nowhere.net
Wed Mar 3 12:38:51 CET 2004


In article <oueksar0tu.fsf at andlx-anamika.cisco.com>, Ganesan R wrote:

>> python2.3-pgsql - A Python DB-API 2.0 interface to PostgreSQL v7.x
>> python2.3-popy - module providing access to PostgreSQL from Python2.3
>> python2.3-psycopg - Python 2.3 module for PostgreSQL
>> python2.3-pygresql - PostgreSQL module for Python
> 
> I prefer the first one - it's BSD licensed, actively maintained and
> supported. It's also very compatible with the python SQLite binding which I
> use regularly.

PyGreSQL (the first one), doesn't seem to handle boolean's correctly in
Python 2.3.  Is there a workaround (aside from translating back and forth
 before saving)?  This is the version that ships with Red Hat 9.
 
I use psycopg usually, though I try to test my progs with all of them
(except popy).  It's not too hard to accomadate all of them with just a few
tweaks (usually in the way they handle booleans), since they all use
pyformat.

pyPgSQL does seem to have the best win32 support.

Dave Cook



More information about the Python-list mailing list