DB API Module Comparison¶
Legacy Wiki Page
This page was migrated from the old MoinMoin-based wiki. Information may be outdated or no longer applicable. For current documentation, see python.org.
Name |
RDBMS |
Development Status |
License |
OS |
Python versions |
Quoting styles |
Thread support |
Extras |
Limitations |
|---|---|---|---|---|---|---|---|---|---|
Any ODBC compatible Database (SQL Server, DB2, PostgreSQL, MySQL) |
Stable |
MIT |
Linux, Windows, Mac OS/X, Unix |
2.4+ and 3.2+ |
qmark |
Yes |
Catalog methods, access columns by name |
No output parameters in stored procedure calls |
|
Stable |
BSD |
Windows, BSD, Linux, MacOS X |
2.6+ |
qmark |
? |
? |
? |
||
Any ODBC compatible Database, e.g. DB2, MS SQL Server, etc. |
Stable |
Commercial |
Unix, Windows, MacOS X |
1.5.2+ |
qmark |
Yes |
Catalog Methods. Commercial support |
None |
|
Any ODBC compatible Database, e.g. DB2, MS SQL Server, etc. |
Stable |
Commercial |
Any Python Platform |
2.3 |
qmark |
Yes |
Client-Server Product, Catalog Methods. Commercial support |
None |
|
Stable |
Python/GPL |
Unix, Windows, MacOS X |
1.5.2+ |
format |
None |
Dictionary cursors, insert_id() |
? |
||
Stable |
GPL |
Unix, Windows, MacOS X |
1.5.2-2.2+ |
format,pyformat |
yes (conn. pooling) |
typecasting objects |
? |
||
Stable |
BSD |
Unix, Windows, MacOS X |
2.1+ |
pyformat |
None |
PgResultSet, typecasting objects, notifications |
- |
||
N/A (embedded SQLite engine) |
Stable |
Python |
Unix, Windows |
2.1+ |
pyformat |
GIL is released while SQLite processes queries |
Write SQL aggregates/functions in Python |
- |
|
Any ODBC or ADO compatible |
Stable |
LGPL |
Windows |
1.5.2+ |
qmark |
? |
? |
? |
|
MS SQL Server or Sybase |
Stable |
LGPL |
All |
2.4+ |
pyformat |
None |
None |
None |
|
sapdbapi |
Stable |
LGPL |
Windows, Unix, Linux |
1.5.2+ |
qmark, numeric, named |
Yes |
administration api |
? |
|
ibm_db |
DB2, Informix |
? |
Apache 2 |
Windows, Unix, Linux |
? |
? |
Yes |
? |
Informix support limited to v11+ |
Stable |
BSD |
Windows, Unix, Linux |
2.2+ |
qmark,numeric,named |
Yes |
Dictionary Cursors |
None known |