Re: [GENERAL] interfaces for python

2004-10-07 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 CGI

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 las

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 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 Replicat

Re: [GENERAL] interfaces for python

2004-10-07 Thread Pierre-Frédéric 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 tool

Re: [GENERAL] interfaces for python

2004-10-07 Thread Bo Lorentsen
On Thu, 2004-10-07 at 06:13, Scott Frankel wrote: > PyGreSQL? I will recommend pygresql, as the only thing don't like about it is its funny name :-) It's fast and quite feature complete, and have been used for big projects like Zope. /BL ---(end of broadcast)---

[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. d