An implementation of the psycopg2 module using cffi_. The module is currently compatible with Psycopg 2.5.
.. _cffi: https://cffi.readthedocs.io
You can install
psycopg2cffi from PyPI::
pip install psycopg2cffi
Or from source::
python setup.py install
Installation requirements are the same as for
psycopg2 - you must
pg_config somewhere on your
Python development headers (
python-dev or similar), and
Installation was tested on Ubuntu 12.04, Ubuntu 14.04, CentOS (RHEL 5.0),
OS X 10.8 - 10.10.
It should be possible to make it work on Windows, but I did not test it.
This module works under CPython 2.7+, CPython 3.5+, PyPy 2 and PyPy 3 (PyPy version should be at least 2.0, which is ancient history now).
To use this package with Django or SQLAlchemy invoke a compatibility
hook (for example, from
settings.py in case of Django, or
psycopg2.py file in site-packages of your virtual env)::
from psycopg2cffi import compat compat.register()
This will map
psycopg2, so now any code that
import psycopg2 will use
Submit issues to https://github.com/chtd/psycopg2cffi/issues
If you notice that
psycopg2cffi under PyPy is noticeably slower than
psycopg2 under CPython, submit this to the issues too - it should
not be the case.
This is a port of (Michael van Tellingen port https://github.com/mvantellingen/psycopg2-ctypes of Alex Gaynor's RPython port (https://bitbucket.org/alex_gaynor/pypy-postgresql/overview) of psycopg2 to Python + ctypes) to cffi.
The main motivation for a port was speed - the writeup with benchmarks is here: http://chtd.ru/blog/bystraya-rabota-s-postgres-pod-pypy/?lang=en
To run tests, install
pytest and run them with::
Note that for
cffi>=1.0 you need to run
python setup.py develop
_libpq.so (if you changed bindings).
cffi<1.0 (only PyPy 2.5 and below) you need to run
python setup.py install once to generate
otherwise each import will run config and notify tests will fail.
You can also run Django tests. You need to checkout Django source, add psycopg2 compat as described above, and, from the root of the Django checkout::
PYTHONPATH=`pwd` ./tests/runtests.py \ --settings=psycopg2cffi.tests.psycopg2_tests.testconfig
In case of problems with Django tests, see official Django docs https://docs.djangoproject.com/en/dev/internals/contributing/writing-code/unit-tests/#running-the-unit-tests
2.9.0 (27 Jan 2021) +++++++++++++++++++
2.8.1 (31 July 2018) ++++++++++++++++++++
Release date added
2.8.0 (31 July 2018) ++++++++++++++++++++
Python 3.7 support by unimariJo (#92) and farrokhi (#101).
async_ should be used instead of
async in public APIs
(but the change is backwards compatible,
async is still supported as an alias).
2.7.7 (13 November 2017) ++++++++++++++++++++++++
2.7.6 (11 August 2017) ++++++++++++++++++++++
2.7.5 (31 October 2016) +++++++++++++++++++++++
Windows wheels support added by ryoyoko (#69).
2.7.4 (01 April 2016) +++++++++++++++++++++
Fix a regression with error handling when establishing the connection (#61)
2.7.3 (29 February 2016) ++++++++++++++++++++++++
Fix a bug with non-ascii error messages (#56)
2.7.2 (06 August 2015) ++++++++++++++++++++++
Fixes for FreeBSD support by Andrew Coleman
2.7.1 (20 June 2015) ++++++++++++++++++++
2.7.0 (21 May 2015) +++++++++++++++++++
Use cffi 1.0, which makes installation more robust, and import is faster. cffi<1.0 is used now only for PyPy 2.5 or below.
2.6.1 (08 Feb 2015) +++++++++++++++++++
Fixing things that were broken in 2.6.0:
2.6.0 (24 Jan 2015) +++++++++++++++++++
2.5.1 (14 May 2014) +++++++++++++++++++
2.5.0 (3 Sep 2013) ++++++++++++++++++
Older releases lack release notes, first release of psycopg2cffi around Nov 2012.