Python Database Interface Module

From: http://wiki.woodpecker.org.cn/moin/DatabaseModules
Dedicated database connection module

MySQL

• Mysql-the most popular open source database
  

• Mysql-Python -- Python interface of MySQL
  

  • Http://dustman.net/andy/python/python-and-mysql-presentation from mysql-Python
    

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
  

  • Pysqlite document data collection
    

PostgreSQL

• Postgresql-an open-source database with more powerful functions and a longer history than MySQL
  

  • PostgreSQL Chinese Network
    

• 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

• Pydb2-the python interface of DB2, which also includes several gadgets
  

SAP DB

• Sapdbapi-Python interface of SAP DB
  

Infomix

• Informixdb
  

Interbase

• Kinterbasdb -- Python interfaces of INTERBASE 4.0 and 5.0
  

INGRES

• Ingmod
  

Sybase

• Sybase module for python -- DB-API 2.0 interface for 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

• Thinksql-A commercial database product with built-in Python Interfaces
  

Matisse

• Matisse-commercial database product Matisse, built-in Python binding support, non-DB-API compatibility.
  

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

• Zxjdbc-DB-API 2.0 interface designed for Jython, built on the underlying JDBC interface. It is included in the release version later than Jython 2.1.
  

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.