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

Maintainer:
Psycopg Developers
Driver:
Not yet selected
Licence:
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:
Bazaar
Programming languages:
Python, C

All packages Packages in Distributions

Get Involved

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

Downloads

Latest version is 2.0.14
released on 2010-03-13

All downloads