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

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

• pyodbc: http://pyodbc.sourceforge.net

• 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.

• 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