MySQL

URL

http://www.mysql.com/

licence

GPL

platforms

Unix, win32

Pros

• Many administration tools from third parties
• Widely deployed
• Regarded as being fast
• Modular storage engines and interesting clustering features

Cons

• Reputation for only basic SQL support (entry-level SQL 92) and deviations from the standards. Many interesting features (subqueries, views, triggers, ...) are included in the latest version (5 and above), but are missing in prior versions.

• Some gotchas (documented but unexpected features).

DB API 2.0 Drivers

MySQL for Python

URL

http://sourceforge.net/projects/mysql-python

licence

GNU General Public License (GPL), Python License (CNRI Python License), Zope Public License

platforms

OS Independent

Python versions

2.3 - 2.5

MySQL on-line documentation, additional forums (maintainer does not currently read these)

mxODBC

URL

http://www.egenix.com/products/python/mxODBC/

Licence

eGenix Commercial License

Platforms

Windows, Linux, MacOS X, FreeBSD, Solaris, AIX

Python versions

2.1 - 2.5

mxODBC is compatible with the MySQL ODBC driver on Windows and Unix.

pyodbc

URL

http://code.google.com/p/pyodbc

License

MIT

Platforms

Windows, Linux, MacOS X, FreeBSD, Solaris, Any (source provided)

Python versions

2.4 - 2.6

Actively maintained Open Source project.

Precompiled binaries are available for Windows. RedHat Enterprise Linux, Centos, and Fedora have precompiled RPMs available in their Extras repositories.

Supported Python Applications

• Zope

• A MySQL driver exists for PyDO (Python Data Objects)