Text of wiki.python.org › python › database › DbApiModuleComparison.html as Styx crawled it on Nov 19, 2026. The page may have changed since. Only its words are kept, without pictures or layout.

Open the live page

DB API Module Comparison - Python Wiki

Python Wiki Python Wiki / Python Wiki / Database Programming / DB API Module Comparison View as Markdown 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 pyodbc 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 fdb Firebird Stable BSD Windows, BSD, Linux, MacOS X 2.6+ 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 Previous DB API FAQ Next DB API Sucks