Differences between revisions 35 and 36
Revision 35 as of 2008-11-15 14:01:28
Size: 1788
Editor: localhost
Comment: converted to 1.6 markup
Revision 36 as of 2008-12-08 12:36:21
Size: 231
Comment:
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
This page should help in choosing the right database system.

== Relational Database Systems ==

Database systems employing a relational model, with support for SQL.

  * IBM [[DB2]]
  * [[Firebird]] (and Interbase)
  * [[Informix]]
  * [[Ingres]]
  * [[MySQL]]
  * [[Oracle]]
  * [[PostgreSQL]]
  * [[SAP DB]] (also known as "MaxDB")
  * Microsoft [[SQL Server]]
  * [[Sybase]]

The following database systems are more oriented towards embedded applications:

  * GadFly
  * [[SQLite]]
  * [[ThinkSQL]]

To add new entries (choose DatabaseTemplate when creating the page).

== Database Interfaces and APIs ==

  * Most databases have ODBC support; see the section below on ODBC modules.
  * Java databases usually support JDBC, and can be used from Jython.
  * See also DbApiModuleComparison

== ODBC Support ==

 * ceODBC: http://ceodbc.sourceforge.net

 * pyodbc: http://pyodbc.sourceforge.net

 * [[http://www.egenix.com/products/python/mxODBC|mxODBC]]: A commercial Python extension that provides ODBC connectivity on Windows, Linux, Mac OS X, FreeBSD and many other Unix platforms.

 * [[http://www.egenix.com/products/python/mxODBCConnect|mxODBC Connect]]: A commercial client-server product that allows connecting Python to ODBC compatible databases running on remote servers without requiring an ODBC driver on the client side.

 * ODBTPAPI: http://benjiyork.com/odbtp.html

== ADO Support ==

 * adodbapi (http://adodbapi.sourceforge.net/): A Python module that makes it easy to use Microsoft ADO for connecting to databases and other data sources.

== Non-Relational Databases ==

  * MetaKit
  * [[ZODB]]
  * [[BerkeleyDB]]
  * [[KirbyBase]]
  * [[Durus]]
  * [[atop]]
  * [[buzhug]]
If you are looking for a database system to use with your Python application, please have a look at the DatabaseInterfaces page which lists database systems that have Python interfaces available.

Choosing a Database System

If you are looking for a database system to use with your Python application, please have a look at the DatabaseInterfaces page which lists database systems that have Python interfaces available.

ChoosingDatabase (last edited 2008-12-08 12:36:21 by MarcAndreLemburg)

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