Re: [GENERAL] interfaces for python

2004-10-08 Thread Brian Morton
I've been using psycopg for a few years and it works very well. I agree with the other posters. I would also add that a quick look at SQLObject is worthwhile for a python programmer. Very handy. http://sqlobject.org I have no affiliation with the product but I am a fan. Been using it as my

[GENERAL] interfaces for python

2004-10-07 Thread Scott Frankel
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.

Re: [GENERAL] interfaces for python

2004-10-07 Thread Pierre-Frdric Caillaud
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

Re: [GENERAL] interfaces for python

2004-10-07 Thread Steven Klassen
* Pierre-Frédéric Caillaud [EMAIL PROTECTED] [2004-10-07 10:45:57 +0200]: I'd advise psycopg as the fastest one (by a factor of 10x on large selects). I second this recommendation. -- Steven Klassen - Lead Programmer Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Replication

Re: [GENERAL] interfaces for python -- thanks

2004-10-07 Thread Scott Frankel
Thanks for the responses! I have selected psycopg based on: - your recommendations (though massively parallel connections aren't currently likely in my environment - my success in building the target (with kudos props to their install documentation)

Re: [GENERAL] interfaces for python

2004-10-07 Thread Gaetano Mendola
Steven Klassen wrote: * Pierre-Frédéric Caillaud [EMAIL PROTECTED] [2004-10-07 10:45:57 +0200]: I'd advise psycopg as the fastest one (by a factor of 10x on large selects). I second this recommendation. Also because this interface is not affected by the idle in transaction, indeed as the last