Differences between revisions 16 and 17
Revision 16 as of 2008-05-18 09:14:38
Size: 2020
Editor: dslb-084-057-052-145
Comment:
Revision 17 as of 2008-11-15 14:00:56
Size: 2032
Editor: localhost
Comment: converted to 1.6 markup
Deletions are marked like this. Additions are marked like this.
Line 17: Line 17:
 * [http://www.python.org/dev/peps/pep-0249/ PEP 249: Python Database API Specification v2.0].  * [[http://www.python.org/dev/peps/pep-0249/|PEP 249: Python Database API Specification v2.0]].
Line 21: Line 21:
 * [http://initd.org/pub/software/psycopg/dbapi20programming.pdf DB-API how-to] (PDF).  * [[http://initd.org/pub/software/psycopg/dbapi20programming.pdf|DB-API how-to]] (PDF).
Line 32: Line 32:
 * [http://www.python.org/dev/peps/pep-0248/ PEP 248: Python Database API Specification v1.0].  * [[http://www.python.org/dev/peps/pep-0248/|PEP 248: Python Database API Specification v1.0]].
Line 38: Line 38:
  * [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.   * [[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.
Line 44: Line 44:
  * [http://dmoz.org/Computers/Programming/Databases/ Programming:Databases] category on dmoz.org   * [[http://dmoz.org/Computers/Programming/Databases/|Programming:Databases]] category on dmoz.org
Line 52: Line 52:
  * [http://www.matisse.com/product_information/language_bindings/lang_python.html Matisse Software] provides Python bindings for their object database.   * [[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.

  • ChoosingDatabase -- lists databases supported by Python libraries.

  • DatabaseInterfaces -- another list of databases accessible from Python. (Should merge this list with the above one...)

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.

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.