Python Programming

Python DB API

• Become A Famous Fashion Designer
• Oil Painting Techniques, How to Oil Paint
• Non-surgical Face Lift Alternatives

The quest to provide a standard way to interface to database systems drove a group of people to develop Python Database API. The Python DB API is maintained by the Database Special Interest Group (DB-SIG). For more information, check out their Web site at http://www.python.org/sigs/db-sig/.

The following list shows all the database modules that currently implement the Python DB API specification proposed by the DB-SIG. This means that after you understand the API, you will be able to handle, in a similar way, all the databases that are manipulated by the following modules:

• GadFly— A simple relational database system implemented in Python based on the SQL Structured Query Language, including a DB-API compliant interface. Maintained by Aaron Watters.

http://www.chordate.com/gadfly.html

• Informix— Currently maintained by Stephen J. Turner. http://starship.python.net/crew/sturner/informixdb.html

• Informix (Kinfxdb)— A completely new Informix module, called Kinfxdb. Maintained by Alexander Kuznetsov.

http://thor.prohosting.com/~alexan/

• Interbase (Kinterbasdb)— An interface for Interbase 4.0 and 5.0. Maintained by Alexander Kuznetsov. http://thor.prohosting.com/~alexan/Kinterbasdb/

• MySQL— A MySQL module that is thread-safe and aims for compatibility with the 2.0 DB-API. It requires a newer version of MySQL, version 3.22.19 or higher.

http://dustman.net/andy/python/MySQLdb/

• mxODBC— The mxODBC package provides a nearly 100% Python DB API compliant interface to databases that are accessible via the ODBC API. Many databases include ODBC libraries, so this might be the only module you need. Maintained by M. A. Lemburg.

http://starship.python.net/crew/lemburg/mxODBC.html

• ODBC— This module is currently available in the PythonWin distribution. It's public domain code, but unfortunately has no designated support person(s). The best option for support is to ask questions on comp.lang.python newsgroups, where other PythonWin users can answer them.

http://www.python.org/windows/win32/odbc.html

• DCOracle— An open source interface to Oracle from Digital Creations.

http://www.zope.org/Products/DCOracle/

• Sybase— Maintained by Peter Godman. http://starship.python.net/crew/pgodman/

This is the information available at the time this book was written. For an updated list of modules, check out http://www.python.org/topics/database/modules.html.

0 0