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
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.
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
* 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
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)
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