MySQL
- URL
- 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
- licence
- GNU General Public License (GPL), Python License (CNRI Python License), Zope Public License
- platforms
- OS Independent
- Python versions
- 2.3 - 2.5
[http://dev.mysql.com/downloads/python.html MySQL on-line documentation, additional forums] (maintainer does not currently read these)
mxODBC
- URL
- 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)