Differences between revisions 25 and 27 (spanning 2 versions)
Revision 25 as of 2008-02-18 14:20:23
Size: 1799
Editor: 91
Comment:
Revision 27 as of 2008-07-21 15:20:39
Size: 1960
Editor: 65
Comment: Added InformixDB
Deletions are marked like this. Additions are marked like this.
Line 11: Line 11:
||ibm_db||["DB2"] DB2, Informix||?||Apache 2||Windows, Unix, Linux||?||?||Yes||||?|| ||ibm_db||["DB2"], Informix||?||Apache 2||Windows, Unix, Linux||?||?||Yes||||?||
||[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

[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

?

[http://informixdb.sourceforge.net 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.