DatabaseProgramming
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.
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.
Talks
Future development
DbApi3 -- discussion of possible topics for a DB-API 3.
Historical development
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.
Matisse Software provides Python bindings for their object database.