Common database interface modules in Python

Source: Internet
Author: User
Tags db2 ibm db2 interbase sybase


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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.