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
pyPgSQL does seem to have the best win32 support.
More information about the Python-list