Common database interface modules in Python

• This entry collects common database interface modules in Python, including various mainstream relational databases and some common interfaces.
• Unless otherwise specified, all (or partially implemented) The DB-API standards.

• For more extensive Python database technology, see Python database development overview.

 

1. Dedicated database connection module

 

1.1. MySQL

• MySQL
  -- The most popular open source database

• Mysql-Python
  -- MySQL Python Interface

  • Http://dustman.net/andy/python/python-and-mysql
    -- Mysql-Python author's presentation

 

1.2. SQLite

• SQLite
  -- Small and lightweight embedded database

• Pysqlite
  -- SQLite's semi-official Python interface. Python 2.5 and later have become the standard library sqlite3

  • Pysqlite document 

 

1.3. PostgreSQL

• PostgreSQL
  -- Open-source databases that are more powerful than MySQL and have a long history

  • 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

 

1.4. 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

 

1.5. IBM DB2

• Pydb2
  -- The python interface of DB2 also includes several gadgets

 

1.6. SAP DB

• Sapdbapi
  -- Python interface of SAP DB

 

1.7. infomix

• Informixdb

 

1.8. InterBase

• Kinterbasdb
  -- Python interfaces of INTERBASE 4.0 and 5.0

 

1.9. INGRES

• Ingmod

 

1.10. Sybase

• Sybase module for python
  -- Sybase DB-API 2.0 interface

 

1.11. 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, 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
  Connect to SQL Server.

• Some common problems: ntext Data Types of SQL Server are not supported. Change ntext fields to nvarchar. -- Neo.

 

1.12. thinksql

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

 

1.13. Matisse

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

 

2. Common Database Interface Module

 

2.1. ODBC

• Mxodbc
  -- A part of the popular MX toolkit is also the only commercial product (not paid 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 -- with pythonwin
  Lack of accompanying modules, documents and Maintenance

 

2.2. 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.

 

2.3. sqlrelay

• Sqlrelay
  -- General database connection pool in UNIX environment, supports a variety of databases and programming languages, provides their own Python interface, non-DB-API compatible.

 

3. Other modules

 

3.1. Gadfly

• Gadfly
  Is a lightweight in-memory relational database implemented by python, which itself provides DB-API-compatible access interfaces.