Differences between revisions 80 and 93 (spanning 13 versions)
⇤ ← Revision 80 as of 2007-06-16 13:24:32 →
Size: 2803
Editor: AndrewKuchling
Comment:
← Revision 93 as of 2008-11-15 13:59:57 → ⇥
Size: 3715
Editor: localhost
Comment: converted to 1.6 markup
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
[[TableOfContents]] <<TableOfContents>>
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 17: Line 23:
  * PoPy and PyGreSQL are [http://www.zope.org/Members/tm/Full_Announce merging]
 * PostgresPy: http://python.projects.postgresql.org/		   * 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
Line 21: Line 31:
Line 23: Line 34:
 * ["sipPQ"]
* [[sipPQ]]
Line 25: Line 38:

Supports the 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 29: Line 42:
Line 30: Line 44:
Line 32: Line 47:
Line 34: Line 50:
Line 35: Line 52:

Supports the ''Oracle Instant Client'' which is available for Windows and many popular Unix platforms.		   * 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.
Line 39: Line 55:
 * PyDB2: http://sourceforge.net/projects/pydb2
Line 41: Line 56:

DB2's native CLI is ODBC compatible and mxODBC can link directly against these libraries. It also supports the DB2 ODBC driver on Windows.

== Firebird/InterBase ==
 * KInterbasDB: http://kinterbasdb.sourceforge.net/		  * More info on [[DB2]]
Line 48: Line 59:
 * sybase: http://www.object-craft.com.au/projects/sybase/
* sybase
  * old: http://www.object-craft.com.au/projects/sybase/
  * new: http://python-sybase.sourceforge.net/
Line 50: Line 65:

Supports Sybase ASE and Sybase Anywhere.		   * Supports Sybase ASE and Sybase Anywhere.
Line 54: Line 68:
Line 55: Line 70:
Line 56: Line 72:

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.		   * 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.
Line 60: Line 75:
Line 61: Line 77:
Line 62: Line 79:

Note: The Informix ODBC drivers are included in the Informix CSDK.		   * Note: The Informix ODBC drivers are included in the Informix CSDK.
Line 66: Line 82:
Line 67: Line 84:

== Microsoft SQL Server ==

 * See [[SQL Server]]
Line 70: Line 91:
== 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.
Line 71: Line 100:
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.
Line 73: Line 101:
http://www.pythonweb.org/projects/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.

Contents

  1. Relational database
    1. MySQL
    2. PostgreSQL
    3. Oracle
    4. IBM DB2
    5. Sybase
    6. MaxDB/SAPDB
    7. Informix
    8. Ingres
    9. Microsoft SQL Server
  2. Native Python Databases
    1. buzhug
    2. SnakeSQL

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

Note that you have to enable the advanced option "Use bytea for lo" in case you want to work with BLOBs.

Oracle

IBM DB2

  • More info on DB2

Sybase

MaxDB/SAPDB

Informix

Ingres

Microsoft SQL Server

Native Python Databases

buzhug

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

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.

DatabaseInterfaces (last edited 2020-12-09 09:29:13 by MarcAndreLemburg)

Unable to edit the page? See the FrontPage for instructions.