1237
Comment:
|
← Revision 28 as of 2011-11-26 09:05:05 ⇥
2210
Undo spam
|
Deletions are marked like this. | Additions are marked like this. |
Line 1: | Line 1: |
Resources on using databases with Python | Starting point for learning about using databases from Python. |
Line 3: | Line 3: |
* ChoosingDatabase -- lists databases supported by Python libraries. | == Relational Databases == |
Line 5: | Line 5: |
* DatabaseInterfaces -- another list of databases accessible from Python. (Should merge this list with the above one...) | Relational databases are the most widely used type of database, storing information as tables containing a number of rows. |
Line 7: | Line 8: |
* HigherLevelDatabaseProgramming -- wrappers that provide simpler or higher-level database interfaces, such as object/relational mappers and SQL generators. | * DatabaseInterfaces -- List of available Python databases interfaces. This also helps you choose the right database for your application. |
Line 9: | Line 10: |
* DatabaseBooks -- lists a few recommended titles for learning about databases. These books aren't Python-specific. |
|
Line 13: | Line 12: |
The DB-API is a specification for a common interface to relational databases, currently at version 2.0. | The DB-API is a specification for a common interface to relational databases. The current version of the specification is version 2.0. |
Line 15: | Line 15: |
* [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 18: | Line 18: |
* If you are looking for a DBAPI-2 HowTo, try [http://initd.org/pub/software/psycopg/dbapi20programming.pdf this one] (PDF). | |
Line 20: | Line 19: |
Future development of the API: | * 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 === |
Line 25: | Line 31: |
Historical development: | === Historical development === |
Line 27: | Line 33: |
* [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 29: | Line 35: |
== Related tools == | |
Line 30: | Line 37: |
See also: | * 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 == |
Line 33: | Line 50: |
* 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
DbApi3 -- discussion of possible topics for a DB-API 3.
Historical development
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.
Matisse Software provides Python bindings for their object database.