psycopg2 - Python-PostgreSQL Database Adapter

Navigation

Project links

Statistics

View statistics for this project via Libraries.io, or by using our public dataset on Google BigQuery

Meta

License: GNU Library or Lesser General Public License (LGPL), Zope Public License (LGPL with exceptions or ZPL)

Author: Federico Di Gregorio

Maintainers

Avatar for asmodai from gravatar.com asmodai Avatar for jerickso from gravatar.com jerickso Avatar for piro from gravatar.com piro

Classifiers

Project description

Psycopg is the most popular PostgreSQL database adapter for the Python programming language. Its main features are the complete implementation of the Python DB API 2.0 specification and the thread safety (several threads can share the same connection). It was designed for heavily multi-threaded applications that create and destroy lots of cursors and make a large number of concurrent “INSERT”s or “UPDATE”s.

Psycopg 2 is mostly implemented in C as a libpq wrapper, resulting in being both efficient and secure. It features client-side and server-side cursors, asynchronous communication and notifications, “COPY TO/COPY FROM” support. Many Python types are supported out-of-the-box and adapted to matching PostgreSQL data types; adaptation can be extended and customized thanks to a flexible objects adaptation system.

Psycopg 2 is both Unicode and Python 3 friendly.

Documentation

Documentation is included in the ‘doc’ directory and is available online.

Installation

If your pip version supports wheel packages it should be possible to install a binary version of Psycopg including all the dependencies. Just run:

pip install psycopg2

If you want to build Psycopg from source you will need some prerequisite (a C compiler, Python and libpq development packages). If you have what you need the standard:

python setup.py build
sudo python setup.py install

should work no problem. In case you have any problem check the ‘install’ and the ‘faq’ documents in the docs or online.

For any other resource (source code repository, bug tracker, mailing list) please check the project homepage.

Linux/OSX:Linux and OSX build status
Windows:Windows build status

Project details

Project links

Statistics

View statistics for this project via Libraries.io, or by using our public dataset on Google BigQuery

Meta

License: GNU Library or Lesser General Public License (LGPL), Zope Public License (LGPL with exceptions or ZPL)

Author: Federico Di Gregorio

Maintainers

Avatar for asmodai from gravatar.com asmodai Avatar for jerickso from gravatar.com jerickso Avatar for piro from gravatar.com piro

Classifiers


Release history Release notifications

2.8.4

2.8.3

2.8.2

2.8.1

2.8

2.7.7

2.7.6.1

2.7.6

2.7.5

2.7.4

2.7.3.2

2.7.3.1

2.7.3

2.7.2

This version

2.7.1

2.7

2.6.2

2.6.1

2.6

2.5.5

2.5.4

2.5.3

2.5.2

2.5.1

2.5

2.4.6

2.4.5

2.4.4

2.4.3

2.4.2

2.4.1

2.4

2.3.2

2.3.1

2.3.0

2.2.2

2.2.1

2.2.0

2.0.14

2.0.13

2.0.12

2.0.11

2.0.10

2.0.8

2.0.7

2.0.6

2.0.5.1

2.0.4

2.0.3

2.0.2

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for psycopg2, version 2.7.1
Filename, size File type Python version Upload date Hashes
Filename, size psycopg2-2.7.1-cp26-cp26m-manylinux1_i686.whl (2.4 MB) File type Wheel Python version cp26 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp26-cp26m-manylinux1_x86_64.whl (2.7 MB) File type Wheel Python version cp26 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp26-cp26mu-manylinux1_i686.whl (2.4 MB) File type Wheel Python version cp26 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp26-cp26mu-manylinux1_x86_64.whl (2.7 MB) File type Wheel Python version cp26 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp27-cp27m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl (1.5 MB) File type Wheel Python version cp27 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp27-cp27m-manylinux1_i686.whl (2.4 MB) File type Wheel Python version cp27 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp27-cp27m-manylinux1_x86_64.whl (2.7 MB) File type Wheel Python version cp27 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp27-cp27mu-manylinux1_i686.whl (2.4 MB) File type Wheel Python version cp27 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp27-cp27mu-manylinux1_x86_64.whl (2.7 MB) File type Wheel Python version cp27 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp27-cp27m-win32.whl (805.2 kB) File type Wheel Python version cp27 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp27-cp27m-win_amd64.whl (930.3 kB) File type Wheel Python version cp27 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp33-cp33m-manylinux1_i686.whl (2.4 MB) File type Wheel Python version cp33 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp33-cp33m-manylinux1_x86_64.whl (2.6 MB) File type Wheel Python version cp33 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp33-cp33m-win32.whl (809.6 kB) File type Wheel Python version cp33 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp33-cp33m-win_amd64.whl (928.6 kB) File type Wheel Python version cp33 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp34-cp34m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl (1.5 MB) File type Wheel Python version cp34 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp34-cp34m-manylinux1_i686.whl (2.4 MB) File type Wheel Python version cp34 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp34-cp34m-manylinux1_x86_64.whl (2.7 MB) File type Wheel Python version cp34 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp34-cp34m-win32.whl (809.4 kB) File type Wheel Python version cp34 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp34-cp34m-win_amd64.whl (928.6 kB) File type Wheel Python version cp34 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp35-cp35m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl (1.5 MB) File type Wheel Python version cp35 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp35-cp35m-manylinux1_i686.whl (2.4 MB) File type Wheel Python version cp35 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp35-cp35m-manylinux1_x86_64.whl (2.7 MB) File type Wheel Python version cp35 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp35-cp35m-win32.whl (800.5 kB) File type Wheel Python version cp35 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp35-cp35m-win_amd64.whl (939.3 kB) File type Wheel Python version cp35 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp36-cp36m-macosx_10_6_intel.macosx_10_9_intel.macosx_10_9_x86_64.macosx_10_10_intel.macosx_10_10_x86_64.whl (1.5 MB) File type Wheel Python version cp36 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp36-cp36m-manylinux1_i686.whl (2.4 MB) File type Wheel Python version cp36 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp36-cp36m-manylinux1_x86_64.whl (2.7 MB) File type Wheel Python version cp36 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp36-cp36m-win32.whl (800.4 kB) File type Wheel Python version cp36 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1-cp36-cp36m-win_amd64.whl (939.2 kB) File type Wheel Python version cp36 Upload date Hashes View hashes
Filename, size psycopg2-2.7.1.tar.gz (421.0 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page