.. image:: https://travis-ci.org/chtd/psycopg2cffi.svg?branch=master
:target: https://travis-ci.org/chtd/psycopg2cffi
.. contents::
An implementation of the psycopg2 module using cffi.
The module is currently compatible with Psycopg 2.5.
Installation
------------
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
have ``libpq`` headers, ``pg_config`` somewhere on your ``$PATH``,
Python development headers (``python-dev`` or similar), and ``ffi-dev``
for ``cffi``.
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
from a ``psycopg2.py`` file in site-packages of your virtual env)::
from psycopg2cffi import compat
compat.register()
This will map ``psycopg2cffi`` to ``psycopg2``, so now any code that
does ``import psycopg2`` will use ``psycopg2cffi``.
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
Development
-----------
To run tests, install ``pytest`` and run them with::
py.test psycopg2cffi
Note that for ``cffi>=1.0`` you need to run ``python setup.py develop``
to rebuild ``_libpq.so`` (if you changed bindings).
And for ``cffi<1.0`` (only PyPy 2.5 and below) you need to run
``python setup.py install`` once to generate ``psycopg2cffi/_config.py``,
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
Release notes
-------------
2.9.0 (27 Jan 2021)
+++++++++++++++++++
New features:
- Add execute_batch and execute_values to psycopg2cffi.extras by @fake-name in #98
- psycopg2cffi.extras: add fetch argument to execute_values() by @intelfx in #119
Bug fixes:
- Fix for async keyword argument when creating a connection by @donalm in #104
- Allow adapters to be passed as arguments of cursor's execute() by @amigrave in #107
- Fix installation with old cffi by dand-oss in #116
Test changes:
- Dropped support for python 2.6, 3.3, 3.4 by @thedrow in #109
- Added support for python 3.8 by @thedrow in #108
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)
++++++++++++++++++++++++
Bugfixes:
- Support installation under Postgres 10 by jimbattin (#90)
2.7.6 (11 August 2017)
++++++++++++++++++++++
Bugfixes:
- Named cursors fix (affects newer Django) by danchr (#81)
- Python 3 fixes in extras by avanov (#83)
- Null check added in fast parser utils by malthe (#79)
2.7.5 (31 October 2016)
+++++++++++++++++++++++
Windows wheels support added by ryoyoko (#69).
Bugfixes:
- Non-ascii notice messages fixed by asterite3 (#72)
- AsIs with non-text/bytes fixed by jinty (#64)
- Silent failures in copy_from and copy_to fixed by gobbledygook88 (#62)
- Infinite recursion error fixed in errorcodes.lookup (#68)
- Typos in README fixed by PavloKapyshin (#66)
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)
++++++++++++++++++++
JSONB support
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:
- Fix issue #31 - bigint on 32-bit
- Fix issue #32 - register_type and unicode
2.6.0 (24 Jan 2015)
+++++++++++++++++++
- Python 3 support
- A bit faster reading of int, long, float, double fields
2.5.1 (14 May 2014)
+++++++++++++++++++
- Small bugfixes
2.5.0 (3 Sep 2013)
++++++++++++++++++
- Bugfixes and a lot of compatibility work by Daniele Varrazzo
Older releases lack release notes, first release of psycopg2cffi around Nov 2012.
Raw data
{
"_id": null,
"home_page": "http://github.com/chtd/psycopg2cffi",
"name": "psycopg2cffi",
"maintainer": "",
"docs_url": null,
"requires_python": "",
"maintainer_email": "",
"keywords": "",
"author": "Konstantin Lopuhin",
"author_email": "konstantin.lopuhin@chtd.ru",
"download_url": "https://files.pythonhosted.org/packages/ac/d8/45bd0870d45964f6f92367fd383e8abb8f57815360654ef913c5417f0714/psycopg2cffi-2.9.0.tar.gz",
"platform": "any",
"description": ".. image:: https://travis-ci.org/chtd/psycopg2cffi.svg?branch=master\n :target: https://travis-ci.org/chtd/psycopg2cffi\n\n.. contents::\n\nAn implementation of the psycopg2 module using cffi.\nThe module is currently compatible with Psycopg 2.5.\n\nInstallation\n------------\n\nYou can install ``psycopg2cffi`` from PyPI::\n\n pip install psycopg2cffi\n\nOr from source::\n\n python setup.py install\n\nInstallation requirements are the same as for ``psycopg2`` - you must\nhave ``libpq`` headers, ``pg_config`` somewhere on your ``$PATH``,\nPython development headers (``python-dev`` or similar), and ``ffi-dev``\nfor ``cffi``.\nInstallation was tested on Ubuntu 12.04, Ubuntu 14.04, CentOS (RHEL 5.0),\nOS X 10.8 - 10.10.\nIt should be possible to make it work on Windows, but I did not test it.\n\nThis module works under CPython 2.7+, CPython 3.5+, PyPy 2 and PyPy 3\n(PyPy version should be at least 2.0, which is ancient history now).\n\nTo use this package with Django or SQLAlchemy invoke a compatibility\nhook (for example, from ``settings.py`` in case of Django, or\nfrom a ``psycopg2.py`` file in site-packages of your virtual env)::\n\n from psycopg2cffi import compat\n compat.register()\n\nThis will map ``psycopg2cffi`` to ``psycopg2``, so now any code that\ndoes ``import psycopg2`` will use ``psycopg2cffi``.\n\nSubmit issues to https://github.com/chtd/psycopg2cffi/issues\n\nIf you notice that ``psycopg2cffi`` under PyPy is noticeably slower than\n``psycopg2`` under CPython, submit this to the issues too - it should\nnot be the case.\n\nThis is a port of (Michael van Tellingen port\nhttps://github.com/mvantellingen/psycopg2-ctypes\nof Alex Gaynor's RPython port\n(https://bitbucket.org/alex_gaynor/pypy-postgresql/overview) of psycopg2 to\nPython + ctypes) to cffi.\n\nThe main motivation for a port was speed - the writeup with benchmarks\nis here: http://chtd.ru/blog/bystraya-rabota-s-postgres-pod-pypy/?lang=en\n\nDevelopment\n-----------\n\nTo run tests, install ``pytest`` and run them with::\n\n py.test psycopg2cffi\n\nNote that for ``cffi>=1.0`` you need to run ``python setup.py develop``\nto rebuild ``_libpq.so`` (if you changed bindings).\nAnd for ``cffi<1.0`` (only PyPy 2.5 and below) you need to run\n``python setup.py install`` once to generate ``psycopg2cffi/_config.py``,\notherwise each import will run config and notify tests will fail.\n\nYou can also run Django tests. You need to checkout Django source, add\npsycopg2 compat as described above, and, from the root of the Django checkout::\n\n PYTHONPATH=`pwd` ./tests/runtests.py \\\n --settings=psycopg2cffi.tests.psycopg2_tests.testconfig\n\nIn case of problems with Django tests, see official Django docs\nhttps://docs.djangoproject.com/en/dev/internals/contributing/writing-code/unit-tests/#running-the-unit-tests\n\nRelease notes\n-------------\n\n2.9.0 (27 Jan 2021)\n+++++++++++++++++++\n\nNew features:\n\n- Add execute_batch and execute_values to psycopg2cffi.extras by @fake-name in #98\n- psycopg2cffi.extras: add fetch argument to execute_values() by @intelfx in #119\n\nBug fixes:\n\n- Fix for async keyword argument when creating a connection by @donalm in #104\n- Allow adapters to be passed as arguments of cursor's execute() by @amigrave in #107\n- Fix installation with old cffi by dand-oss in #116\n\nTest changes:\n\n- Dropped support for python 2.6, 3.3, 3.4 by @thedrow in #109\n- Added support for python 3.8 by @thedrow in #108\n\n2.8.1 (31 July 2018)\n++++++++++++++++++++\n\nRelease date added\n\n2.8.0 (31 July 2018)\n++++++++++++++++++++\n\nPython 3.7 support by unimariJo (#92) and farrokhi (#101).\n``async_`` should be used instead of ``async`` in public APIs\n(but the change is backwards compatible,\n``async`` is still supported as an alias).\n\n\n2.7.7 (13 November 2017)\n++++++++++++++++++++++++\n\nBugfixes:\n\n- Support installation under Postgres 10 by jimbattin (#90)\n\n\n2.7.6 (11 August 2017)\n++++++++++++++++++++++\n\nBugfixes:\n\n- Named cursors fix (affects newer Django) by danchr (#81)\n- Python 3 fixes in extras by avanov (#83)\n- Null check added in fast parser utils by malthe (#79)\n\n\n2.7.5 (31 October 2016)\n+++++++++++++++++++++++\n\nWindows wheels support added by ryoyoko (#69).\n\nBugfixes:\n\n- Non-ascii notice messages fixed by asterite3 (#72)\n- AsIs with non-text/bytes fixed by jinty (#64)\n- Silent failures in copy_from and copy_to fixed by gobbledygook88 (#62)\n- Infinite recursion error fixed in errorcodes.lookup (#68)\n- Typos in README fixed by PavloKapyshin (#66)\n\n\n2.7.4 (01 April 2016)\n+++++++++++++++++++++\n\nFix a regression with error handling when establishing the connection (#61)\n\n\n2.7.3 (29 February 2016)\n++++++++++++++++++++++++\n\nFix a bug with non-ascii error messages (#56)\n\n\n2.7.2 (06 August 2015)\n++++++++++++++++++++++\n\nFixes for FreeBSD support by Andrew Coleman\n\n\n2.7.1 (20 June 2015)\n++++++++++++++++++++\n\nJSONB support\n\n\n2.7.0 (21 May 2015)\n+++++++++++++++++++\n\nUse cffi 1.0, which makes installation more robust, and import is faster.\ncffi<1.0 is used now only for PyPy 2.5 or below.\n\n\n2.6.1 (08 Feb 2015)\n+++++++++++++++++++\n\nFixing things that were broken in 2.6.0:\n\n- Fix issue #31 - bigint on 32-bit\n- Fix issue #32 - register_type and unicode\n\n\n2.6.0 (24 Jan 2015)\n+++++++++++++++++++\n\n- Python 3 support\n- A bit faster reading of int, long, float, double fields\n\n2.5.1 (14 May 2014)\n+++++++++++++++++++\n\n- Small bugfixes\n\n2.5.0 (3 Sep 2013)\n++++++++++++++++++\n\n- Bugfixes and a lot of compatibility work by Daniele Varrazzo\n\n\nOlder releases lack release notes, first release of psycopg2cffi around Nov 2012.\n",
"bugtrack_url": null,
"license": "LGPL",
"summary": ".. image:: https://travis-ci.org/chtd/psycopg2cffi.svg?branch=master",
"version": "2.9.0",
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"md5": "2aaf10ebe3c052747507a5e7842dedf3",
"sha256": "7e272edcd837de3a1d12b62185eb85c45a19feda9e62fa1b120c54f9e8d35c52"
},
"downloads": -1,
"filename": "psycopg2cffi-2.9.0.tar.gz",
"has_sig": false,
"md5_digest": "2aaf10ebe3c052747507a5e7842dedf3",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 65512,
"upload_time": "2021-01-27T13:00:56",
"upload_time_iso_8601": "2021-01-27T13:00:56.775192Z",
"url": "https://files.pythonhosted.org/packages/ac/d8/45bd0870d45964f6f92367fd383e8abb8f57815360654ef913c5417f0714/psycopg2cffi-2.9.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2021-01-27 13:00:56",
"github": true,
"gitlab": false,
"bitbucket": false,
"github_user": "chtd",
"github_project": "psycopg2cffi",
"travis_ci": true,
"coveralls": false,
"github_actions": false,
"tox": true,
"lcname": "psycopg2cffi"
}
JSON
