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 [http://sql-info.de/mysql/gotchas.html 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.4

[http://dev.mysql.com/downloads/python.html 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.

Supported Python Applications

• ["Zope"]
• A MySQL driver exists for ["PyDO"] (Python Data Objects)