|
Size: 803
Comment:
|
Size: 2035
Comment: 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 2: | Line 2: |
| [[TableOfContents]] | |
| Line 4: | Line 3: |
| == Masthead == | = MySQL = |
| Line 7: | Line 6: |
| licence:: GPL | license:: GPL |
| Line 9: | Line 8: |
== 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). ---- |
|
| Line 12: | Line 25: |
| === driver name === | === MySQL for Python === |
| Line 14: | Line 27: |
| URL:: http://dustman.net/andy/python/MySQLdb/ licence:: GPL/Python license platforms:: Unix, win32 Python versions:: 1.5.2 thru 2.2 |
URL:: http://sourceforge.net/projects/mysql-python License:: GNU General Public License (GPL), Python License (CNRI Python License), Zope Public License Platforms:: OS Independent Python versions:: 2.3 - 2.5 |
| Line 19: | Line 32: |
| ==== Extensions to DB API ==== | [[http://dev.mysql.com/downloads/python.html|MySQL on-line documentation, additional forums]] (maintainer does not currently read these) |
| Line 21: | Line 34: |
| * several alternative cursor classes which can be used with cursor(cursorclass) on the connection object * additional methods info() and insert_id() in the cursor classes |
=== mxODBC === |
| Line 24: | Line 36: |
| ==== Comments ==== | URL:: http://www.egenix.com/products/python/mxODBC/ License:: eGenix Commercial License Platforms:: Windows, Linux, MacOS X, FreeBSD, Solaris, AIX Python versions:: 2.1 - 2.5 |
| Line 26: | Line 41: |
| == Other Drivers == | mxODBC is compatible with the MySQL ODBC driver on Windows and Unix. |
| Line 28: | Line 43: |
| === driver name === | === pyodbc === |
| Line 30: | Line 45: |
| URL:: licence:: platforms:: Python versions:: |
URL:: http://code.google.com/p/pyodbc License:: MIT Platforms:: Windows, Linux, MacOS X, FreeBSD, Solaris, Any (source provided) Python versions:: 2.4+ |
| Line 35: | Line 50: |
| ==== Programming Model ==== | Actively maintained Open Source project. |
| Line 37: | Line 52: |
| ==== Comments ==== | 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:: https://launchpad.net/myconnpy License:: GNU GPL v2 Platforms:: Any (presumably) Python versions:: 2.3 or greater ---- |
| Line 41: | Line 65: |
| == Pros == == Cons == |
* [[Zope]] * A MySQL driver exists for [[PyDO]] (Python Data Objects) |
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