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]

Re: Best python postgres module?

Roland Heiber wrote:[color=blue]
> 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.[/color]

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