DatabaseInterfaces (original) (raw)

This wiki is in the process of being archived due to lack of usage and the resources necessary to serve it — predominately to bots, crawlers, and LLM companies. Edits are discouraged.
Pages are preserved as they were at the time of archival. For current information, please visit python.org.
If a change to this archive is absolutely needed, requests can be made via the infrastructure@python.org mailing list.

Contents

1. Generic Database Interfaces and APIs
   1. ODBC Support
   2. ADO Support
2. Database Interfaces for Relational Database Systems
   1. General Purpose Database Systems
   2. Data Warehouse Database Systems
   3. Database Systems for Embedding Into Applications
3. Non-Relational Databases
   1. Record-based Databases
   2. XML Databases
   3. Graph Databases
4. Native Python Databases

This page lists database interfaces available for Python. It may also help in finding a suitable database engine for you to use in your Python database applications.

Generic Database Interfaces and APIs

• The Python standard for database interfaces is the Python DB-API (PEP 249) Most Python database interfaces adhere to this standard.
• 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

• See ODBC

ADO Support

• See ADO

Database Interfaces for Relational Database Systems

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

General Purpose Database Systems

• IBM DB2
• Firebird (and Interbase)
• Informix
• Ingres
• MySQL
• Oracle
• PostgreSQL
• SAP DB (also known as "MaxDB")
• Microsoft SQL Server
• Microsoft Access
• Sybase
• InterSystems IRIS

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

Data Warehouse Database Systems

• Teradata
• IBM Netezza

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

Database Systems for Embedding Into Applications

The following database systems are more oriented towards embedded applications:

• asql
• GadFly
• SQLite
• ThinkSQL

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

Non-Relational Databases

Record-based Databases

Databases working on flat files or fixed records.

• MetaKit
• ZODB
• BerkeleyDB
• KirbyBase
• Durus
• atop
• buzhug

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

XML Databases

• 4Suite server
• Oracle/Sleepycat DB XML (howto)

Graph Databases

• Neo4j

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

Native Python Databases

• buzhug
• SnakeSQL