|
Size: 3697
Comment:
|
Size: 3648
Comment: added link to SQL_Server
|
| 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 10: | Line 9: |
| == MySQL == mysql-python: http://sourceforge.net/projects/mysql-python |
|
| Line 11: | Line 13: |
| Line 14: | Line 17: |
| Line 15: | Line 19: |
| Line 16: | Line 21: |
| Line 18: | Line 24: |
| Line 19: | Line 26: |
| * pg_proboscis: DB-API 2.0 and GreenTrunk Interfaces [http://pypi.python.org/pypi?:action=display&name=pg_proboscis] * pg_pqueue: PQ 3.0 Protocol elements [http://pypi.python.org/pypi?:action=display&name=pg_pqueue] |
* 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 23: | Line 31: |
| Line 25: | Line 34: |
| Line 26: | Line 36: |
| Line 27: | Line 38: |
| * 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 30: | Line 42: |
| Line 31: | Line 44: |
| Line 33: | Line 47: |
| Line 35: | Line 50: |
| Line 39: | Line 55: |
| * 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 44: | Line 59: |
| Line 45: | Line 61: |
| Line 49: | Line 66: |
| Line 50: | Line 68: |
| Line 54: | Line 73: |
| Line 55: | Line 75: |
| Line 59: | Line 80: |
| Line 60: | Line 82: |
== Microsoft SQL Server == * See ["SQL_Server"] |
|
| Line 64: | Line 90: |
| Line 71: | Line 98: |
The contents of this page are being merged into the ChoosingDatabase page.
Relational database
Databases based on a relational model, with support for SQL.
MySQL
mysql-python: http://sourceforge.net/projects/mysql-python
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
Microsoft SQL Server
- See ["SQL_Server"]
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.