HTTP/2 302
server: nginx
date: Thu, 17 Jul 2025 08:54:46 GMT
content-type: text/plain; charset=utf-8
content-length: 0
x-archive-redirect-reason: found capture at 20100709140556
location: https://web.archive.org/web/20100709140556/https://wiki.python.org/moin/DbApiModuleComparison
server-timing: captures_list;dur=0.818069, exclusion.robots;dur=0.029028, exclusion.robots.policy;dur=0.017665, esindex;dur=0.017426, cdx.remote;dur=42.931986, LoadShardBlock;dur=161.820632, PetaboxLoader3.datanode;dur=82.903720
x-app-server: wwwb-app201
x-ts: 302
x-tr: 232
server-timing: TR;dur=0,Tw;dur=0,Tc;dur=1
set-cookie: SERVER=wwwb-app201; path=/
x-location: All
x-rl: 0
x-na: 0
x-page-cache: MISS
server-timing: MISS
x-nid: DigitalOcean
referrer-policy: no-referrer-when-downgrade
permissions-policy: interest-cohort=()
HTTP/2 200
server: nginx
date: Thu, 17 Jul 2025 08:54:47 GMT
content-type: text/html; charset=utf-8
x-archive-orig-date: Fri, 09 Jul 2010 14:05:55 GMT
x-archive-orig-server: Apache/2.2.9 (Debian) mod_fastcgi/2.4.6 mod_python/3.3.1 Python/2.5.2 mod_ssl/2.2.9 OpenSSL/0.9.8g mod_wsgi/2.5
x-archive-orig-vary: Cookie,User-Agent,Accept-Language
x-archive-orig-content-length: 14591
x-archive-orig-connection: close
x-archive-guessed-content-type: text/html
x-archive-guessed-charset: utf-8
memento-datetime: Fri, 09 Jul 2010 14:05:56 GMT
link:
; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Sat, 27 May 2006 19:17:32 GMT", ; rel="prev memento"; datetime="Thu, 01 May 2008 16:40:29 GMT", ; rel="memento"; datetime="Fri, 09 Jul 2010 14:05:56 GMT", ; rel="next memento"; datetime="Thu, 23 Jun 2011 06:52:28 GMT", ; rel="last memento"; datetime="Tue, 22 Apr 2025 06:15:52 GMT"
content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org
x-archive-src: 51_16_20100709065624_crawl101-c/51_16_20100709140517_crawl103.arc.gz
server-timing: captures_list;dur=0.662343, exclusion.robots;dur=0.029894, exclusion.robots.policy;dur=0.017659, esindex;dur=0.013754, cdx.remote;dur=5.313021, LoadShardBlock;dur=423.647515, PetaboxLoader3.datanode;dur=266.150145, PetaboxLoader3.resolve;dur=316.108952, load_resource;dur=167.799573
x-app-server: wwwb-app201
x-ts: 200
x-tr: 660
server-timing: TR;dur=0,Tw;dur=0,Tc;dur=1
x-location: All
x-rl: 0
x-na: 0
x-page-cache: MISS
server-timing: MISS
x-nid: DigitalOcean
referrer-policy: no-referrer-when-downgrade
permissions-policy: interest-cohort=()
content-encoding: gzip
DbApiModuleComparison - PythonInfo Wiki
Name |
RDBMS |
Development Status |
License |
OS |
Python versions |
Quoting styles |
Thread support |
Extras |
Limitations |
pyodbc |
Any ODBC compatible Database (SQL Server, DB2, PostgreSQL, MySQL) |
Stable |
MIT |
Linux, Windows, Mac OS/X, Unix |
2.4+ |
qmark |
Yes |
Catalog methods, access columns by name |
None |
kinterbasdb |
Firebird and Interbase |
Stable |
BSD |
Windows, BSD, Linux |
1.5.2+ |
qmark |
? |
? |
? |
mxODBC |
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 |
mxODBC Connect |
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 |
MySQLdb |
MySQL |
Stable |
Python/GPL |
Unix, Windows, MacOS X |
1.5.2+ |
format |
None |
Dictionary cursors, insert_id() |
? |
psycopg |
PostgreSQL |
Stable |
GPL |
Unix, Windows, MacOS X |
1.5.2-2.2+ |
format,pyformat |
yes (conn. pooling) |
typecasting objects |
? |
pyPgSQL |
PostgreSQL |
Stable |
BSD |
Unix, Windows, MacOS X |
2.1+ |
pyformat |
None |
PgResultSet, typecasting objects, notifications |
- |
PySQLite |
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 |
- |
adodbapi |
Any ODBC or ADO compatible |
Stable |
LGPL |
Windows |
1.5.2+ |
qmark |
? |
? |
? |
pymssql |
MS SQL Server or Sybase |
Stable |
LGPL |
All |
2.4+ |
pyformat |
None |
None |
None |
sapdbapi |
SAP DB |
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+ |
InformixDB |
Informix |
Stable |
BSD |
Windows, Unix, Linux |
2.2+ |
qmark,numeric,named |
Yes |
Dictionary Cursors |
None known |
EditText (last edited 2009-07-24 18:57:36 by ip-62-143-155-237)
