Differences between revisions 1 and 22 (spanning 21 versions)
Revision 1 as of 2002-07-12 22:29:50
Size: 81
Editor: anonymous
Comment: missing edit-log entry for this revision
Revision 22 as of 2010-11-10 23:46:06
Size: 2210
Editor: ip-62-143-153-202
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
  * ChoosingDatabase
  * HigherLevelDatabaseProgramming
  * ExtendingTheDbApi
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.

 * [[http://www.python.org/dev/peps/pep-0249/|PEP 249: Python Database API Specification v2.0]].

 * DbApiFaq

 * UsingDbApiWithPostgres

=== Talks ===

 * [[http://www.egenix.com/library/presentations/EuroPython2008-Using-the-Python-Database-API/|Talk video and slides: Using the Python Database API]]

 * [[http://www.zope.de/tagung/Dresden_2010/Python-Datenbankprogrammierung_mal.pdf|Slides: Datenbankprogrammierung mit dem Python Database API]] (in German)
=== Future development ===

 * DbApi3 -- discussion of possible topics for a DB-API 3.
 * ExtendingTheDbApi

=== Historical development ===

 * [[http://www.python.org/dev/peps/pep-0248/|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.

  * [[http://sqlrelay.sourceforge.net/|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.

  * [[http://dmoz.org/Computers/Programming/Databases/|Programming:Databases]] category on dmoz.org

== Non-relational Databases ==

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

  * XmlDatabases

  * [[http://www.matisse.com/product_information/language_bindings/lang_python.html|Matisse Software]] provides Python bindings for their object database.

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

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

Non-relational Databases

DatabaseProgramming (last edited 2011-11-26 09:05:05 by MarcAndreLemburg)

Unable to edit the page? See the FrontPage for instructions.