2035
Comment: Spelling: Licence --> license; removed upper bound from pyodbc versions so it doesn't have to be updated all the time.
|
2650
Corrected outdated Pros and Platforms; Corrected outdated Cons; Updating Connector/Python.
|
Deletions are marked like this. | Additions are marked like this. |
Line 6: | Line 6: |
license:: GPL platforms:: Unix, win32 |
license:: GPLv2 platforms:: Unix, win32, win64, MacOS X, i5/OS |
Line 11: | Line 11: |
* Easy to install and administer * Support for many SQL Features (v5.0 and up): * Good compliance with SQL standards * Foreign Keys (using InnoDB) * Stored Routines * Views * Triggers * Subqueries (as of v4.1) * Partitioning (as of v5.1) * ACID compliant (InnoDB and NDB storage engines) * Character set support * Build-in Replication |
|
Line 18: | Line 30: |
* 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). |
* Early versions (v4.1 and earlier) have the reputation for only basic SQL support (entry-level SQL 92) and deviations from the standards. Many interesting features (views, triggers,..) are included in the latest version (5 and above), but are missing in prior versions. Check [[http://dev.mysql.com/doc/refman/5.1/en/server-sql-mode.html|SQL Modes]] for making MySQL more strict. * Some [[http://sql-info.de/mysql/gotchas.html|gotchas]] for MySQL v4.1 and earlier. |
Line 59: | Line 71: |
Python versions:: 2.3 or greater | Python versions:: 2.4 or greater * Pure Python implementation of the MySQL protocol. * Maintained by Sun Microsystems, Inc. |
MySQL
- URL
- license
- GPLv2
- platforms
- Unix, win32, win64, MacOS X, i5/OS
Pros
- Easy to install and administer
- Support for many SQL Features (v5.0 and up):
- Good compliance with SQL standards
- Foreign Keys (using InnoDB)
- Stored Routines
- Views
- Triggers
- Subqueries (as of v4.1)
- Partitioning (as of v5.1)
- ACID compliant (InnoDB and NDB storage engines)
- Character set support
- Build-in Replication
- Many administration tools from third parties
- Widely deployed
- Regarded as being fast
- Modular storage engines and interesting clustering features
Cons
Early versions (v4.1 and earlier) have the reputation for only basic SQL support (entry-level SQL 92) and deviations from the standards. Many interesting features (views, triggers,..) are included in the latest version (5 and above), but are missing in prior versions. Check SQL Modes for making MySQL more strict.
Some gotchas for MySQL v4.1 and earlier.
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.4 or greater
- Pure Python implementation of the MySQL protocol.
- Maintained by Sun Microsystems, Inc.