Registered 2006-08-04 by Psycopg Developers

DB-API 2.0 compliant PostgreSQL database adapter for Python

psycopg is a PostgreSQL database adapter for the Python programming language. It was written from scratch with the aim of being very small and fast, and stable as a rock. The main advantages of psycopg are that it supports the full Python DBAPI-2.0, being thread safe at level 2 and providing some very usefull extensions like the user-defined type casters.

psycopg is different from the other database adapter because it was designed for heavily multi-threaded applications that create and destroy lots of cursors and make a conspicuous number of concurrent INSERTs or UPDATEs. Every open Python connection keeps a pool of real (UNIX or TCP/IP) connections to the database. Every time a new cursor is created, a new connection does not need to be opened; instead one of the unused connections from the pool is used. That makes psycopg very fast in typical client-server applications that create a servicing thread every time a client request arrives.

There are confirmed reports of psycopg compiling and running on Linux and FreeBSD on i386, Solaris, MacOS X and Windows (both MSC and cygwin).

Project information

Psycopg Developers
Not yet selected
GNU GPL v2, Zope Public Licence

RDF metadata

View full history Series and milestones

2.0.x series is the current focus of development.

All code Code

Version control system:
Programming languages:
Python, C

All packages Packages in Distributions

Get Involved

  • warning
    Report a bug
  • warning
    Ask a question
  • warning
    Help translate


Latest version is 2.0.14
released on 2010-03-13

All downloads