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