2043
Comment: Added MySQL Connector/Python.
|
2035
Spelling: Licence --> license; removed upper bound from pyodbc versions so it doesn't have to be updated all the time.
|
Deletions are marked like this. | Additions are marked like this. |
Line 6: | Line 6: |
licence:: GPL | license:: GPL |
Line 22: | Line 22: |
Line 28: | Line 28: |
Licence:: GNU General Public License (GPL), Python License (CNRI Python License), Zope Public License Platforms:: OS Independent |
License:: GNU General Public License (GPL), Python License (CNRI Python License), Zope Public License Platforms:: OS Independent |
Line 37: | Line 37: |
Licence:: eGenix Commercial License | License:: eGenix Commercial License |
Line 46: | Line 46: |
Licence:: MIT | License:: MIT |
Line 48: | Line 48: |
Python versions:: 2.4 - 2.6 | Python versions:: 2.4+ |
Line 57: | Line 57: |
Licence:: GNU GPL v2 | License:: GNU GPL v2 |
MySQL
- URL
- license
- 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
- License
- 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
- License
- 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
- License
- MIT
- Platforms
- Windows, Linux, MacOS X, FreeBSD, Solaris, Any (source provided)
- Python versions
- 2.4+
Actively maintained Open Source project.
Precompiled binaries are available for Windows. Red Hat Enterprise Linux, Centos, and Fedora have precompiled RPMs available in their Extras repositories.
MySQL Connector/Python
- URL
- License
- GNU GPL v2
- Platforms
- Any (presumably)
- Python versions
- 2.3 or greater