|
Size: 1473
Comment:
|
Size: 1483
Comment: converted to 1.6 markup
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 19: | Line 19: |
| * Some [http://sql-info.de/mysql/gotchas.html gotchas] (documented but unexpected features). | * Some [[http://sql-info.de/mysql/gotchas.html|gotchas]] (documented but unexpected features). |
| Line 30: | Line 30: |
| Python versions:: 2.4 | Python versions:: 2.3 - 2.5 |
| Line 32: | Line 32: |
| [http://dev.mysql.com/downloads/python.html MySQL on-line documentation, additional forums] (maintainer does not currently read these) | [[http://dev.mysql.com/downloads/python.html|MySQL on-line documentation, additional forums]] (maintainer does not currently read these) |
| Line 47: | Line 47: |
| * ["Zope"] * A MySQL driver exists for ["PyDO"] (Python Data Objects) |
* [[Zope]] * A MySQL driver exists for [[PyDO]] (Python Data Objects) |
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 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
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.