Differences between revisions 1 and 90 (spanning 89 versions)
Revision 1 as of 2003-02-06 19:12:23
Size: 1097
Editor: MikeRovner
Comment:
Revision 90 as of 2008-09-11 18:51:06
Size: 3593
Editor: mail
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
= DBMS interfaces =
Things you connect to.
[[TableOfContents]]

The contents of this page are being merged into the ChoosingDatabase page.

= Relational database =

Databases based on a relational model, with support for SQL.
Line 4: Line 10:
mysql-python: http://sourceforge.net/projects/mysql-python
Line 5: Line 13:

 * 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.
Line 6: Line 42:

 * cx_Oracle: http://www.python.net/crew/atuining/cx_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"]
Line 7: Line 59:
== MSSQL ==
== BerkeleyDb ==
Line 10: Line 60:
 * sybase: http://www.object-craft.com.au/projects/sybase/
Line 11: Line 62:
= Datafiles interfaces =
Things you open.
 * mxODBC: http://www.egenix.com/products/python/mxODBC/
  * Supports Sybase ASE and Sybase Anywhere.
Line 14: Line 65:
== xBase ==
Which stands for .dbf files interface.[[BR]]
.bdf files were produced by several old systems like dBase(II,III,IV), Fox(Base,Pro)
 * xBase (http://linux.techass.com/projects/xdb/)
 * http://www.fiby.at/dbfpy.html
 * http://www.sequiter.com/products/Python/
 * http://cbbrowne.com/info/xbase.html
 * http://www.e-bachmann.dk/docs/xbase.htm
== MaxDB/SAPDB ==
Line 23: Line 67:
== dbm ==
A family of old unix plain hash tables. Has varieties like dbm, ndbm, gdbm, dbmdb185.[[BR]]
See [http://www.python.org/doc/current/lib/module-anydbm.html anydbm],
[http://www.python.org/doc/current/lib/module-dumbdbm.html dumbdbm],
[http://www.python.org/doc/current/lib/module-dbhash.html dbhash],
[http://www.python.org/doc/current/lib/module-bsddb.html bsddb],
[http://www.python.org/doc/current/lib/module-dbm.html dbm],
[http://www.python.org/doc/current/lib/module-gdbm.html gdbm]
in Python Standard Library.
 * sapdb: http://dev.mysql.com/doc/maxdb/interfaces.html
Line 33: Line 69:
== gadfly ==  * 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.

TableOfContents

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

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.

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

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