From: Joshua D. Drake <jd@commandprompt.com>
To: sdavis2@mail.nih.gov
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Python interfaces
Date: Fri, 15 Sep 2006 11:30:37 -0700
Message-ID: <450AF14D.2030903@commandprompt.com> (raw)
In-Reply-To: <200609151352.20668.sdavis2@mail.nih.gov>
References: <200609151352.20668.sdavis2@mail.nih.gov>
Sean Davis wrote:
> I am in the process of moving development from perl to python. Under perl,
> there was DBI, the be-all-end-all of database interfaces. Under python,
> there is a plethora of options.
Actually that isn't correct. The python drivers all adhere to DB API,
the drives themselves are just a tad different. You can see the spec on
DB API here:
http://www.python.org/dev/peps/pep-0249/> Is there a recommended one for postgres? It
> will be mainly used in a web environment, so the ability to work
> asynchronously is not that important.
We use psycopg2 for all python work.
Sincerely,
Joshua D. Drake
I am interested in maintaining
> database introspection (which the DB-API 2.0 is conspicuously short on)
> tools, as well as niceties such as automatic escape-quoting, etc, that are
> pretty standard in perl. Any suggestions?
>
> Thanks,
> Sean
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: jd@commandprompt.com, sdavis2@mail.nih.gov
Subject: Re: Python interfaces
In-Reply-To: <450AF14D.2030903@commandprompt.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox