|
Size: 3476
Comment:
|
Size: 3593
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 3: | Line 3: |
| The contents of this page are being merged into the ChoosingDatabase page. |
The contents of this page are being merged into the ChoosingDatabase page. |
| Line 8: | Line 6: |
| Line 11: | Line 10: |
| Line 14: | Line 14: |
| Line 15: | Line 16: |
| Line 16: | Line 18: |
| Line 18: | Line 21: |
| * PostgresPy: http://python.projects.postgresql.org/ | * pg/python: http://python.projects.postgresql.org/ * pg_proboscis: DB-API 2.0 and GreenTrunk Interfaces http://python.projects.postgresql.org/project/pg_proboscis.html * pg_pqueue: PQ 3.0 Protocol elements http://python.projects.postgresql.org/project/pg_pqueue.html |
| Line 21: | Line 28: |
| Line 23: | Line 31: |
| Line 24: | Line 33: |
| Line 25: | Line 35: |
| * Supports the [http://www.postgresql.org/ftp/odbc/versions/ PostgreSQL ODBC driver] on both Windows and Unix. Note that you have to enable the advanced option "Use bytea for lo" in case you want to work with BLOBs. | * Supports the [http://www.postgresql.org/ftp/odbc/versions/ PostgreSQL ODBC driver] on both Windows and Unix. Note that you have to enable the advanced option "Use bytea for lo" in case you want to work with BLOBs. |
| Line 28: | Line 39: |
| Line 29: | Line 41: |
| Line 31: | Line 44: |
| Line 33: | Line 47: |
| Line 37: | Line 52: |
| * PyDB2: http://sourceforge.net/projects/pydb2 * mxODBC: http://www.egenix.com/products/python/mxODBC/ * DB2's native CLI is ODBC compatible and mxODBC can link directly against these libraries. It also supports the DB2 ODBC driver on Windows. |
* More info on ["DB2"] |
| Line 42: | Line 56: |
| Line 43: | Line 58: |
| Line 47: | Line 63: |
| Line 48: | Line 65: |
| Line 52: | Line 70: |
| Line 53: | Line 72: |
| Line 57: | Line 77: |
| Line 62: | Line 83: |
| Line 69: | Line 91: |
| Line 70: | Line 93: |
== MySQL == mysql-python: http://sourceforge.net/projects/mysql-python |
The contents of this page are being merged into the ChoosingDatabase page.
Relational database
Databases based on a relational model, with support for SQL.
PostgreSQL
- psycopg
psycopg1: http://initd.org/projects/psycopg1
psycopg2: http://initd.org/projects/psycopg2
pyPgSQL: http://pypgsql.sourceforge.net/
PyGreSQL: http://www.pygresql.org/
PoPy: http://sourceforge.net/projects/popy
PoPy and PyGreSQL are [http://www.zope.org/Members/tm/Full_Announce merging]
pg/python: http://python.projects.postgresql.org/
pg_proboscis: DB-API 2.0 and GreenTrunk Interfaces http://python.projects.postgresql.org/project/pg_proboscis.html
pg_pqueue: PQ 3.0 Protocol elements http://python.projects.postgresql.org/project/pg_pqueue.html
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
- ["sipPQ"]
mxODBC: http://www.egenix.com/products/python/mxODBC/
Supports the [http://www.postgresql.org/ftp/odbc/versions/ PostgreSQL ODBC driver] on both Windows and Unix.
Note that you have to enable the advanced option "Use bytea for lo" in case you want to work with BLOBs.
Oracle
DCOracle: http://www.zope.org/Products/DCOracle/
- This is for old Oracle versions (7 and 8).
DCOracle2: http://www.zope.org/Members/matt/dco2
- For Oracle 8i and up.
mxODBC: http://www.egenix.com/products/python/mxODBC/
Supports the [http://www.oracle.com/technology/tech/oci/instantclient/index.html Oracle Instant Client] which is available for Windows and many popular Unix platforms.
IBM DB2
- More info on ["DB2"]
Sybase
mxODBC: http://www.egenix.com/products/python/mxODBC/
- Supports Sybase ASE and Sybase Anywhere.
MaxDB/SAPDB
mxODBC: http://www.egenix.com/products/python/mxODBC/
- MaxDB/SAPDB's native CLI is ODBC compatible and mxODBC can link directly against the CLI libs on Unix. It also supports the ODBC driver on Windows.
Informix
InformixDB: http://informixdb.sourceforge.net/
mxODBC: http://www.egenix.com/products/python/mxODBC/
- Note: The Informix ODBC drivers are included in the Informix CSDK.
Ingres
ingresdbi: http://www.ingres.com
Native Python Databases
buzhug
[http://buzhug.sourceforge.net/ buzhug] is a pure-Python database engine, using a Pythonic, no-SQL syntax.
The data is stored and accessed on disk (it is not an in-memory database). The implementation has been designed to make all operations, and especially selection, as fast as possible with an interpreted language.
A limited benchmark using the same use cases as SQLite's author shows that buzhug is much faster than other pure-Python modules (KirbyBase, gadfly). SQLite, which is implemented in C, is faster, but only less than 3 times on the average.
SnakeSQL
[http://www.pythonweb.org/projects/snakesql/ SnakeSQL] is a pure Python SQL database written to remove the dependence of the Python Web Modules on 3rd party drivers for non-Python databases like MySQL but designed to be a useful database in its own right.
MySQL
mysql-python: http://sourceforge.net/projects/mysql-python