379
Comment:
|
2237
added pyodbc
|
Deletions are marked like this. | Additions are marked like this. |
Line 1: | Line 1: |
||Name||RDBMS||Development Status||License||OS||Python versions||Quoting styles||Thread support||Extras||Limitations|| ||pyPgSQL||PostgreSQL||Stable||Python||Unix, Windows, MacOS X||2.1+||pyformat||None||-||-|| ||psycopg||PostgreSQL||Stable||GPL||Unix, Windows, MacOS X||?||?||?||?||?|| ||MySQLdb||MySQL||Stable||Python/GPL||Unix, Windows, MacOS X||1.5.2+||format||?||?||?|| |
||'''Name'''||'''RDBMS'''||'''Development Status'''||'''License'''||'''OS'''||'''Python versions'''||'''Quoting styles'''||'''Thread support'''||'''Extras'''||'''Limitations'''|| ||[[http://code.google.com/p/pyodbc|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|| ||[[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 |
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 |
|
Firebird and Interbase |
Stable |
BSD |
Windows, BSD, Linux |
1.5.2+ |
qmark |
? |
? |
? |
|
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 |
|
Stable |
Python/GPL |
Unix, Windows, MacOS X |
1.5.2+ |
format |
None |
Dictionary cursors, insert_id() |
? |
||
Stable |
GPL |
Unix, Windows, MacOS X |
1.5.2-2.2+ |
format,pyformat |
yes (conn. pooling) |
typecasting objects |
? |
||
Stable |
BSD |
Unix, Windows, MacOS X |
2.1+ |
pyformat |
None |
PgResultSet, typecasting objects, notifications |
- |
||
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 |
- |
|
Any ODBC or ADO compatible |
Stable |
LGPL |
Windows |
1.5.2+ |
qmark |
? |
? |
? |
|
MS SQL Server or Sybase |
Stable |
LGPL |
All |
2.4+ |
pyformat |
None |
None |
None |
|
sapdbapi |
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+ |
Stable |
BSD |
Windows, Unix, Linux |
2.2+ |
qmark,numeric,named |
Yes |
Dictionary Cursors |
None known |