Re: [GENERAL] interfaces for python
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 interface until Zope sorts out whether it wants to use DTML or TAL for its web interface. Brian On Oct 6, 2004, at 10:13 PM, Scott Frankel 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
Re: [GENERAL] interfaces for python
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 JDBC interface version this interface delay the transaction open at the first statement. I think that the new postgres rpm shall insert this interface instead the PyGres one. Regards Gaetano Mendola ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
Re: [GENERAL] interfaces for python -- thanks
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) - my ability to pronounce its name ;) Now back to the schema ... Thanks Scott On Oct 6, 2004, at 9:13 PM, Scott Frankel 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 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [GENERAL] interfaces for python
* 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 & Support Services, (503) 667-4564 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [GENERAL] interfaces for python
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
Re: [GENERAL] interfaces for python
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)--- TIP 8: explain analyze is your friend