DatabaseProgramming - Python Wiki (original) (raw)

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