Re: Confusion over Python drivers - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Confusion over Python drivers
Date
Msg-id 201002060140.02703.andres@anarazel.de
Whole thread Raw
In response to Re: Confusion over Python drivers  (Marko Kreen <markokr@gmail.com>)
List pgsql-hackers
On Friday 05 February 2010 21:34:53 Marko Kreen wrote:
> On 2/5/10, Josh Berkus <josh@agliodbs.com> wrote:
> >  > I think another difference is that the Perl DBI interface is very
> >  > rich, whereas the Python DB-API is quite minimal and almost forces
> >  > people to write (incompatible) extensions.  The DB-SIG at Python that
> >  > ought to drive all this is also quite dead, possibly because everyone
> >  > has moved on to SQLAlchemy.
> > 
> > For people who use Python a lot, could I have a list of the deficiencies
> > 
> >  in DBAPI?  I've got my horse and lance ready.
> Psycopg was the leader, especially in web-environments,
> but it has non-obvious license and with dead website it does not
> seem that attractive.  Although it is well-maintained still.
Imho a big problem is that it does way too much itself - i.e. it does not use 
things like PQExecParams but does escaping/parsing itself...
Other people may think thats a good idea - I definitely do not think so.

Andres


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: WIP patch for system-catalog vacuuming via a relation map
Next
From: Marko Kreen
Date:
Subject: Re: Confusion over Python drivers