Projects / psycopg


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.

Operating Systems

Recent releases

  •  28 Mar 2012 21:52

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

    •  13 Jun 2011 17:23

      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.

      •  11 May 2011 14:43

        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.

        •  27 Feb 2011 12:23

          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.

          •  06 Feb 2011 16:15

            Release Notes: This version introduces Python 3 support.


            Project Spotlight


            A Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.