Thread: Python API

Hi all,

I've used to program using psycopg for PostgreSQL connections. But
I've just learnt that, ADOdb has Python support too. I tried to search
the mailing list archives for alternatives but they seem very old
(like discussions from 2003). I'd be so appreciated if somebody could
share his/her own experiences for PostgreSQL Python APIs.

List of PostgreSQL Python APIs which I know: PyGreSQL, psycopg, ADOdb.

Regards.

On Sun, Apr 24, 2005 at 05:50:04PM +0300, Volkan YAZICI wrote:
> 
> I've used to program using psycopg for PostgreSQL connections. But
> I've just learnt that, ADOdb has Python support too. I tried to search
> the mailing list archives for alternatives but they seem very old
> (like discussions from 2003). I'd be so appreciated if somebody could
> share his/her own experiences for PostgreSQL Python APIs.
> 
> List of PostgreSQL Python APIs which I know: PyGreSQL, psycopg, ADOdb.

There's also pyPgSQL but it doesn't appear to have been updated for
almost two years.  Psycopg seems to get the most recommendations;
that's what I use.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/

Michael Fuhr wrote:
> On Sun, Apr 24, 2005 at 05:50:04PM +0300, Volkan YAZICI wrote:
> 
>>I've used to program using psycopg for PostgreSQL connections. But
>>I've just learnt that, ADOdb has Python support too. I tried to search
>>the mailing list archives for alternatives but they seem very old
>>(like discussions from 2003). I'd be so appreciated if somebody could
>>share his/her own experiences for PostgreSQL Python APIs.
>>
>>List of PostgreSQL Python APIs which I know: PyGreSQL, psycopg, ADOdb.
> 
> 
> There's also pyPgSQL but it doesn't appear to have been updated for
> almost two years.  Psycopg seems to get the most recommendations;
> that's what I use.

I would use psycopg. It is what Command Prompt uses exclusively for its
Python/PostgreSQL development. It is under reasonably active development
and the author is responsive when we ask questions.

Sincerely,

Joshua D. Drake
Command Prompt, Inc.

> 

I'm currently using PyPgSQL and it is working fine.  I don't use the libpq directly, but import pyPgSQL, which is a thin wrapper around the Python API.