Python database module

Reference: http://wiki.woodpecker.org.cn/moin/DatabaseModules

Python Database Interface Module: -- Swordsp [13:36:01]

Directory

1. Dedicated database connection module
   1. MySQL
   2. SQLite
   3. PostgreSQL
   4. Oracle
   5. IBM DB2
   6. SAP DB
   7. Infomix
   8. Interbase
   9. INGRES
   10. Sybase
   11. SQL Server
   12. Thinksql
   13. Matisse
2. Common Database Interface Module
   1. ODBC
   2. JDBC
   3. Sqlrelay
3. Other modules
   1. Gadfly

• 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 -- Python interface of MySQL

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

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

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

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, which 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 -- DB-API 2.0 interface for Sybase

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 is tested to support SQL Server 2000 and all service pack levels. pymssql 0.7.4 on Windows. tested to support SQL Server 2000 RTM, sp3a and SP4, and 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.

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 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-modules released with pythonwin, lack of documentation 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 -- Universal Database Connection Pool in UNIX environment, supporting multiple databases andProgramming Language, Provides your 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.