This wiki is in the process of being archived due to lack of usage and the resources necessary to serve it — predominately to bots, crawlers, and LLM companies. Edits are discouraged.
Pages are preserved as they were at the time of archival. For current information, please visit python.org.
If a change to this archive is absolutely needed, requests can be made via the infrastructure@python.org mailing list.

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