Re: Python interfaces

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
solutionssince 1997             http://www.commandprompt.com/