psycopg is a PostgreSQL database adapter for the Python programming language. Its main advantages are that it supports the full Python DBAPI 2.0 and it is thread safe at level 2. 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. The psycopg distribution includes ZPsycopgDA, a Zope Database Adapter.
| Tags | Database Software Development Libraries |
|---|---|
| Licenses | ZPL LGPLv3 |
| Operating Systems | POSIX Windows Windows |
| Implementation | C Python |
Recent releases


Release Notes: This release is mostly bugfixes and and little performance improvements.


Release Notes: This release introduces the management of all session parameters through the new set_session() method and fixes some bugs related to multi-threading and green tasks. It executes fewer queries at connection time, making it just a little bit faster.


Release Notes: This version features a bytea parser to make sure psycopg will work with binary data independently from libpq and PostgreSQL versions; support for non-normalized character encodings; a fix for empty queries; and better error reporting.


Release Notes: This release features support for Python 3.1 and 3.2, improvements in named cursor efficiency, and better support for large objects and Python/PostgreSQL type conversion (bytearray and memoryview to bytea, hstore support). This release also fixes some bugs related to adaptation of composite types, conversion of negative infinities, and some reference leaks.


Release Notes: This version introduces Python 3 support.