Differences between revisions 33 and 34
Revision 33 as of 2008-10-06 16:05:49
Size: 1517
Editor: 121
Comment:
Revision 34 as of 2008-10-31 11:35:06
Size: 1784
Comment:
Deletions are marked like this. Additions are marked like this.
Line 35: Line 35:
Line 39: Line 40:
 * mxODBC: http://www.egenix.com/products/python/mxODBC : A commercial library that provides ODBC connectivity on Windows, Mac OS X, FreeBSD and most other Unix platforms.  * [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.

Choosing a Database System

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

ADO Support

Non-Relational Databases

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

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