Revision 30 as of 2010-02-15 14:19:58

Clear message

PostgreSQL

URL

http://www.postgresql.org/

licence
BSD
platforms

Unix, win32 (NT-based Microsoft operating system)

Pros

From the features page:

Cons

DB API 2.0 Drivers

psycopg2

URL

http://initd.org/psycopg/

Licence
GPL
Platforms
Unix, win32
Python versions
2.3...2.6, 3.0
Maintenance
Active development

Replace the previous psycopg 1. A compatiblility layer is included.

Features server-side cursors, COPY support, advanced Python objects adaptation and PostgreSQL types casting.

Extended documentation available on http://initd.org/psycopg/docs/

PyGreSQL

URL

http://www.pygresql.org/

licence
BSD-like
platforms
Unix, win32
Python versions
2.3 thru 2.6
Maintenance
Last version released is 4.0 (2009-01-01)

psycopg1

URL

http://initd.org/software/initd/psycopg1

Licence
GPL
Platforms
Unix, win32 (beta)
Python versions
Maintenance
development stalled (as of 12/2008)

Extensions to DB API

Comments

pyPgSQL

URL

http://pypgsql.sourceforge.net

Licence
BSD-like (depends on mxDateTime, which may be GPL-incompatible)
Platforms
Unix, win32
Python versions
2.1 thru 2.3
Maintenance
Active, sporatic (as of 10/2003)

Extensions to DB API

mxODBC

URL

http://www.egenix.com/products/python/mxODBC/

Licence
eGenix Commercial License
Platforms
Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
Python versions
2.1 - 2.5

mxODBC is compatible with the PostgreSQL ODBC driver on Windows and Unix.

Note that you have to enable the advanced option "Use bytea for lo" in case you want to work with BLOBs.

pyodbc

URL

http://code.google.com/p/pyodbc

License
MIT
Platforms
Windows, Linux, MacOS X, FreeBSD, Solaris, Any (source provided)
Python versions
2.4 - 2.6

Actively maintained Open Source project.

Precompiled binaries are available for Windows. RedHat Enterprise Linux, Centos, and Fedora have precompiled RPMs available in their Extras repositories.

py-postgresql

URL

http://python.projects.postgresql.org

License
BSD/MIT/PSF
Platforms
Any (windows installers available)
Python version
3.x
Maintenance
Active development

Comments

Python 3 port of pg_proboscis and friends. Pure Python with C optimizations. Prepared statement driven APIs, PG-API.(DB-API is there as well).

Written with efficiency and flexibility in mind. Data is streamed in when requested to do so, and always is streamed in under DB-API.

pg8000

URL

http://pybrary.net/pg8000/

License
BSD
Platforms
Any (windows installers available)
Python version
2,5, 2.6, 3.x

pg8000 is somewhat distinctive in that it is written entirely in Python and does not rely on any external libraries

Other Python Interfaces for PostgreSQL

These entries still need to be updated to the standard format (see above):


Supported Python Applications

Unable to edit the page? See the FrontPage for instructions.