Table 21.8 lists most of the common databases out there along with working Python modules and packages that serve as adapters to those database systems. Note that not all adapters are DB-API-compliant.
Table 21.8. Database-Related Modules and Websites
Name | Online Reference or Description |
|---|
Databases | |
Gadfly | http://gadfly.sf.net |
MySQL | http://mysql.com or http://mysql.org |
MySQLdb a.k.a. MySQL-python | http://sf.net/projects/mysql-python |
PostgreSQL | http://postgresql.org |
psycopg | http://initd.org/projects/psycopg1 |
psycopg2 | http://initd.org/software/initd/psycopg/ |
PyPgSQL | http://pypgsql.sf.net |
PyGreSQL | http://pygresql.org |
PoPy | Deprecated; merged into PyGreSQL project |
SQLite | http://sqlite.org |
pysqlite | http://initd.org/projects/pysqlite |
sqlite3[a] | pysqlite integrated into Python Standard Library; use this one unless you want to download the latest patch |
APSW | http://rogerbinns.com/apsw.html |
MaxDB (SAP) | http://mysql.com/products/maxdb |
sdb | http://dev.mysql.com/downloads/maxdb/7.6.00.html#Python |
sapdb | http://sapdb.org/sapdbPython.html |
Firebird (InterBase) | http://firebird.sf.net |
KInterbasDB | http://kinterbasdb.sf.net |
SQL Server | http://microsoft.com/sql |
pymssql | http://pymssql.sf.net (requires FreeTDS [http://freetds.org]) |
adodbapi | http://adodbapi.sf.net |
Sybase | http://sybase.com |
sybase | http://object-craft.com.au/projects/sybase |
Oracle | http://oracle.com |
cx_Oracle | http://starship.python.net/crew/atuining/cx_Oracle |
DCOracle2 | http://zope.org/Members/matt/dco2 (older, for Oracle8 only) |
Ingres | http://ingres.com |
Ingres DBI | http://ingres.com/products/ Prod_Download_Python_DBI.html |
ingmod | http://www.informatik.uni-rostock.de/~hme/software/ |
ORMs | |
SQLObject | http://sqlobject.org |
SQLAlchemy | http://sqlalchemy.org |
PyDO/PyDO2 | http://skunkweb.sf.net/pydo.html |