Differences between revisions 20 and 29 (spanning 9 versions)
Revision 20 as of 2003-01-26 16:46:02
Size: 1552
Editor: pD9EB0432
Comment:
Revision 29 as of 2008-11-15 13:59:43
Size: 2012
Editor: localhost
Comment: converted to 1.6 markup
Deletions are marked like this. Additions are marked like this.
Line 2: Line 2:
||[http://kinterbasdb.sourceforge.net/ kinterbasdb]||["Firebird"] and Interbase||Stable||BSD||Windows, BSD, Linux||1.5.2+||qmark||?||?||?||
||[http://www.egenix.com/files/python/mxODBC.html 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||
||[http://sourceforge.net/projects/mysql-python MySQLdb]||["MySQL"]||Stable||Python/GPL||Unix, Windows, MacOS X||1.5.2+||format||None||Dictionary cursors, insert_id()||?||
||[http://www.initd.org/software/initd/psycopg psycopg]||["PostgreSQL"]||Stable||GPL||Unix, Windows, MacOS X||1.5.2-2.2+||format,pyformat||yes (conn. pooling)||typecasting objects||?||
||[http://pypgsql.sourceforge.net pyPgSQL]||["PostgreSQL"]||Stable||BSD||Unix, Windows, MacOS X||2.1+||pyformat||None||PgResultSet, typecasting objects, notifications||-||
||[http://pysqlite.sourceforge.net/ PySQLite]||N/A (embedded [http://www.hwaci.com/sw/sqlite/ SQLite] engine)||Alpha||Python||Unix, Windows||2.1+||pyformat||None||Write SQL aggregates/functions in Python||largely typeless||
||[http://adodbapi.sourceforge.net/ adodbapi]||Any ODBC or ADO compatible||Beta||LGPL||Windows||1.5.2+||qmark||?||?||?||
||sapdbapi||["SAP DB"]||Stable||LGPL||Windows, Unix, Linux||1.5.2+||qmark, numeric, named||Yes||administration api||?||
||[[http://kinterbasdb.sourceforge.net/|kinterbasdb]]||[[Firebird]] and Interbase||Stable||BSD||Windows, BSD, Linux||1.5.2+||qmark||?||?||?||
||[[http://www.egenix.com/files/python/mxODBC.html|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||
||[[http://sourceforge.net/projects/mysql-python|MySQLdb]]||[[MySQL]]||Stable||Python/GPL||Unix, Windows, MacOS X||1.5.2+||format||None||Dictionary cursors, insert_id()||?||
||[[http://www.initd.org/software/initd/psycopg|psycopg]]||[[PostgreSQL]]||Stable||GPL||Unix, Windows, MacOS X||1.5.2-2.2+||format,pyformat||yes (conn. pooling)||typecasting objects||?||
||[[http://pypgsql.sourceforge.net|pyPgSQL]]||[[PostgreSQL]]||Stable||BSD||Unix, Windows, MacOS X||2.1+||pyformat||None||PgResultSet, typecasting objects, notifications||-||
||[[http://pysqlite.sourceforge.net/|PySQLite]]||N/A (embedded [[http://www.hwaci.com/sw/sqlite/|SQLite]] engine)||Stable||Python||Unix, Windows||2.1+||pyformat||GIL is released while SQLite processes queries||Write SQL aggregates/functions in Python||-||
||[[http://adodbapi.sourceforge.net/|adodbapi]]||Any ODBC or ADO compatible||Stable||LGPL||Windows||1.5.2+||qmark||?||?||?||
||[[http://sourceforge.net/projects/pymssql|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+||
||[[http://informixdb.sourceforge.net|InformixDB]]||[[Informix]]||Stable||BSD||Windows, Unix, Linux||2.2+||qmark,numeric,named||Yes||Dictionary Cursors||None known||

Name

RDBMS

Development Status

License

OS

Python versions

Quoting styles

Thread support

Extras

Limitations

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

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

DbApiModuleComparison (last edited 2014-05-25 22:08:15 by EtienneRobillard)

Unable to edit the page? See the FrontPage for instructions.