Differences between revisions 30 and 33 (spanning 3 versions)
Revision 30 as of 2008-12-31 06:52:14
Size: 2237
Editor: pool-71-170-121-7
Comment: added pyodbc
Revision 33 as of 2010-11-25 11:51:59
Size: 2517
Editor: gw
Comment: kinterbasdb support only python2.4 or more now
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
||[[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://www.firebirdsql.org/index.php?op=devel&sub=python|kinterbasdb]]||[[Firebird]] and Interbase||Stable||BSD||Windows, BSD, Linux||2.4+||qmark||?||?||?||
||[[http://www.egenix.com/products/python/mxODBC/|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://www.egenix.com/products/python/mxODBCConnect/|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||

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+

qmark

Yes

Catalog methods, access columns by name

None

kinterbasdb

Firebird and Interbase

Stable

BSD

Windows, BSD, Linux

2.4+

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

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

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