From: http://wiki.woodpecker.org.cn/moin/DatabaseModules
Dedicated database connection module
MySQL
SQLite
-
SQLite-small and lightweight embedded database
-
Pysqlite-the semi-official Python interface of SQLite. After Python 2.5, it has become the standard library sqlite3
PostgreSQL
-
Postgresql-an open-source database with more powerful functions and a longer history than MySQL
-
Pygresql-the oldest and most popular PostgreSQL Interface
-
Psycopg2-PostgreSQL driver especially designed for high concurrency Environments
-
Pypgsql-another PostgreSQL interface in the python world
Oracle
-
Oracle-the most powerful and advanced commercial database product in the database Field
-
Dcoracle2 -- Oracle driver produced by Zope
-
Cx_oracle -- another oracle interface module
IBM DB2
SAP DB
Infomix
Interbase
INGRES
Sybase
SQL Server
-
Microsoft SQL Server Module for python -- SQL Server DB-API 2.0 interface
- Pymssql 0.7.1 has passed tests on FreeBSD 5.4, 6.0, NetBSD 2.0.2, Linux with kernel 2.6, Solaris 10/x86, Mac OS X, Windows XP, and other platforms.
- Pymssql 0.7.4 tested and supported SQL Server 2000 and all service pack levels.
Pymssql 0.7.4 on Windows has been tested to support SQL Server 2000 RTM, sp3a and SP4, SQL Server 2005 RTM.
- Other versions of SQL Server may also be supported.
-
Use ms SQL db-library on Windows and freetds on Linux and other platforms to connect to SQL Server.
-
Some common problems: ntext Data Types of SQL Server are not supported. Change ntext fields to nvarchar. -- Neo.
Thinksql
Matisse
Common Database Interface Module
ODBC
-
Mxodbc-a part of the popular MX toolkit, is also the only commercial product (not charged for non-commercial development ). Implemented the vast majority of DB-API 2.0 interfaces.
-
Pyodbc -- Open Source Python ODBC interface, complete implementation of the DB-API 2.0 interface
-
ODBC interface --
Lack of documentation and maintenance modules included with pythonwin
JDBC
Sqlrelay
-
Sqlrelay -- Universal Database Connection Pool in UNIX environment, supports a variety of databases and programming languages, provides their own Python interface, non-DB-API compatibility.
Other modules
Gadfly
Gadfly is a lightweight in-memory relational database implemented by python, which itself provides DB-API-compatible access interfaces.