Best python postgres module?

[Roland Heiber]

Hi,

i recently migrated from mysql to postgresql and did use severel python
postgres-modules. All do what they are designed for, so which one would
you use? psycopg, pygresql, pypgsql? psycopg seems to be the best
solution for heavy traffic/multiple connections .... i have no real
testing environment, so any advice which one to use for different
usecases would be nice.

Thanks, Roland

 

[Dave Brueck]

i recently migrated from mysql to postgresql and did use severel python
postgres-modules. All do what they are designed for, so which one would
you use? psycopg, pygresql, pypgsql? psycopg seems to be the best
solution for heavy traffic/multiple connections .... i have no real
testing environment, so any advice which one to use for different
usecases would be nice.

Hi Roland,

We've been using psycopg (via Zope and straight Python programs) for about a
year and haven't had any problems at all. We don't store much binary data so I
don't know how well psycopg handles blobs and what-not, but performance and
reliability has been fine.

I have no idea how psycopg stacks up against the others; in the end we chose it
because the project appeared to be active, it was easy enough to set up, and a
few test scripts we made all worked (how's that for rigorous evaluation? ;-) ).

HTH,
Dave