Differences between revisions 92 and 93
Revision 92 as of 2008-10-29 18:00:39
Size: 3705
Editor: dor20687
Comment: Update Sybase link
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 23: Line 23:
  * PoPy and PyGreSQL are [http://www.zope.org/Members/tm/Full_Announce merging]   * PoPy and PyGreSQL are [[http://www.zope.org/Members/tm/Full_Announce|merging]]
Line 35: Line 35:
 * ["sipPQ"]  * [[sipPQ]]
Line 38: Line 38:
  * Supports the [http://www.postgresql.org/ftp/odbc/versions/ PostgreSQL ODBC driver] on both Windows and Unix.   * Supports the [[http://www.postgresql.org/ftp/odbc/versions/|PostgreSQL ODBC driver]] on both Windows and Unix.
Line 52: Line 52:
  * 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.   * 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 56: Line 56:
 * More info on ["DB2"]  * More info on [[DB2]]
Line 87: Line 87:
 * See ["SQL_Server"]  * See [[SQL Server]]
Line 93: Line 93:
[http://buzhug.sourceforge.net/ buzhug] is a pure-Python database engine, using a Pythonic, no-SQL syntax. [[http://buzhug.sourceforge.net/|buzhug]] is a pure-Python database engine, using a Pythonic, no-SQL syntax.
Line 101: Line 101:
[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. [[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.

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.