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 -- http://mail.python.org/mailman/listinfo/python-list
