5319
Comment: move py-postgresql comment
|
5918
|
Deletions are marked like this. | Additions are marked like this. |
Line 30: | Line 30: |
* Native Windows version is implemented in the PostgreSQL 8.x version, and just for Windows NT 4.0 / 2000 / XP / 2003. For running on other Windows platform or an older version than 8.0 there is a Cygwin version. | * [To be written] |
Line 129: | Line 129: |
'''Important''': New [[http://code.google.com/p/pg8000/|maintenance fork]] including several bugfixes, compatibility features and extensibility enhancements similar to psycopg2 exposed functionalities. [[http://html.pg8000.googlecode.com/hg/index.html|Up to date documentation]] === PyPyODBC (Pure Python) === URL:: http://code.google.com/p/pypyodbc License:: MIT Platforms:: Windows, Linux Python versions:: 2.4 - 3.3 One pure Python script, runs on CPython / IronPython / PyPy , Version 3.3 / 3.2 / 3.1 / 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux , 32 / 64 bit. Almost totally same usage as pyodbc ( can be seen as a re-implementation of pyodbc in pure Python ). Simple - the whole module is implemented in a single python script with less than 3000 lines. |
PostgreSQL
- URL
- licence
- BSD
- platforms
Unix, win32 (NT-based Microsoft operating system)
Pros
From the features page:
- Good compliance with SQL standards
- Supports many SQL features
- Foreign keys
- Implements all SQL99 join types: inner join, left, right, full outer join, natural join
- Subqueries
- UNION and UNION ALL, INTERSECT and EXCEPT
- Views
- Triggers
- Support for international character sets, multibyte character encodings, Unicode
- Supports many languages for writing server-side functions/procedures and aggregates: Python, C, Perl, Tcl, PL/PgSQL, ...
- ACID compliant
- Support for rollback
- Serializable transaction isolation
- Multi-Version Concurrency Control (MVCC) for highly scalable concurrent applications
Cons
- [To be written]
DB API 2.0 Drivers
psycopg2
- URL
- Licence
- LGPL
- Platforms
- Unix, win32
- Python versions
- 2.4, 2.5, 2.6, 2.7, 3.1, 3.2
- Maintenance
- Active development
Psycopg is the most popular PostgreSQL adapter for the Python programming language. At its core it fully implements the Python DB API 2.0 specifications. Several extensions allow access to many of the features offered by PostgreSQL.
Extended documentation available on http://initd.org/psycopg/docs/
PyGreSQL
- URL
- licence
- BSD-like
- platforms
- Unix, win32
- Python versions
- 2.3 thru 2.6
- Maintenance
- Last version released is 4.0 (2009-01-01)
pyPgSQL
- URL
- Licence
- BSD-like (depends on mxDateTime, which may be GPL-incompatible)
- Platforms
- Unix, win32
- Python versions
- 2.1 thru 2.3
- Maintenance
- Active, sporatic (as of 10/2003)
Extensions to DB API
The fetch methods on cursors return an instances of PgResultSet, which you can use to access rows by index (like in DB-API), dictionary-like or with attributes. This feature can be turned off for a slight performance boost.
- Support for PostgreSQL notifications in the low-level API.
mxODBC
- URL
- Licence
- eGenix Commercial License
- Platforms
- Windows, Linux, MacOS X, FreeBSD, Solaris, AIX
- Python versions
- 2.1 - 2.5
mxODBC is compatible with the PostgreSQL ODBC driver on Windows and Unix.
Note that you have to enable the advanced option "Use bytea for lo" in case you want to work with BLOBs.
pyodbc
- URL
- License
- MIT
- Platforms
- Windows, Linux, MacOS X, FreeBSD, Solaris, Any (source provided)
- Python versions
- 2.4 - 2.6
Actively maintained Open Source project.
Precompiled binaries are available for Windows. RedHat Enterprise Linux, Centos, and Fedora have precompiled RPMs available in their Extras repositories.
py-postgresql
- URL
- License
- BSD/MIT/PSF
- Platforms
- Any (windows installers available)
- Python version
- 3.x
- Maintenance
- Active development
Comments
Python 3 port of pg_proboscis and friends. Pure Python with C optimizations. Prepared statement driven APIs, PG-API.(DB-API is there as well).
Written with efficiency and flexibility in mind. Data is streamed in when requested to do so, and always is streamed in under DB-API.
txpostgres
- URL
- License
- MIT/X/Expat
- Platforms
- Any
A Twisted wrapper for asynchronous PostgreSQL connections.
Uses psycopg2, which exposes the async interfaces of the native PostgreSQL library, libpq.
Can be used as a drop-in replacement for Twisted's adbapi module when working with PostgreSQL. The only part that does not provide 100% compatibility is connection pooling, although pooling provided by txpostgres is very similar to the one Twisted adbapi offers.
pg8000
- URL
- License
- BSD
- Platforms
- Any (windows installers available)
- Python version
- 2,5, 2.6, 3.x
pg8000 is somewhat distinctive in that it is written entirely in Python and does not rely on any external libraries
Important: New maintenance fork including several bugfixes, compatibility features and extensibility enhancements similar to psycopg2 exposed functionalities. Up to date documentation
PyPyODBC (Pure Python)
- URL
- License
- MIT
- Platforms
- Windows, Linux
- Python versions
- 2.4 - 3.3
One pure Python script, runs on CPython / IronPython / PyPy , Version 3.3 / 3.2 / 3.1 / 2.4 / 2.5 / 2.6 / 2.7 , Win / Linux , 32 / 64 bit.
Almost totally same usage as pyodbc ( can be seen as a re-implementation of pyodbc in pure Python ).
Simple - the whole module is implemented in a single python script with less than 3000 lines.
Other Python Interfaces for PostgreSQL
These entries still need to be updated to the standard format (see above):
PoPy: http://sourceforge.net/projects/popy
- No activity since 2003
pgasync: http://jamwt.com/pgasync/
- Asynchronous and pure Python. Speed comparable to C bindings. Special support for Twisted.
bpgsql: http://barryp.org/software/bpgsql/
- Barebones pure-Python PostgreSQL client