DatabaseProgramming

Legacy Wiki Page

This page was migrated from the old MoinMoin-based wiki. Information may be outdated or no longer applicable. For current documentation, see python.org.

Starting point for learning about using databases from Python.

Relational Databases

Relational databases are the most widely used type of database, storing information as tables containing a number of rows.

• DatabaseInterfaces – List of available Python databases interfaces. This also helps you choose the right database for your application.

The DB-API

The DB-API is a specification for a common interface to relational databases. The current version of the specification is version 2.0.

• PEP 249: Python Database API Specification v2.0.

• DbApiFaq

• UsingDbApiWithPostgres

Talks

• Talk video and slides: Using the Python Database API

• Slides: Datenbankprogrammierung mit dem Python Database API (in German)

Future development

• DbApi3 – discussion of possible topics for a DB-API 3.

• ExtendingTheDbApi

Historical development

• PEP 248: Python Database API Specification v1.0.

Related tools

• HigherLevelDatabaseProgramming – wrappers that provide simpler or higher-level database interfaces, such as object/relational mappers and SQL generators.

• SQL Relay is a persistent database connection pooling, proxying and load balancing system for Unix systems, supporting many different databases and languages, including PostgreSQL and Python.

Other resources

• DatabaseBooks – lists a few recommended titles for learning about databases. These books aren’t Python-specific.

• Programming:Databases category on dmoz.org

Non-relational Databases

• PersistenceTools – describes non-relational tools for storing data on disk.

• XmlDatabases

• Matisse Software provides Python bindings for their object database.