I'd advise psycopg as the fastest one (by a factor of 10x on large selects).
On Wed, 6 Oct 2004 21:13:02 -0700, Scott Frankel <[EMAIL PROTECTED]> wrote:
I'd like to know if anyone has recommendations for which Python DB-API 2.0
interface to use with PostGreSQL-7.4.5.
The database and tools to interact with it will be hosted on a MacOS 10.3.x machine.
The db schema represents a small production studio environment with only a handful
of users. db connection will be intermittent.
pyPgSQL? PyGreSQL?
Anything I should consider?
Thanks in advance! Scott
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match