|
Size: 566
Comment:
|
Size: 3104
Comment: added mypysql as it is one of the first python3 mysql connectors and it worked for me, perhaps it will work for somebody else
|
| 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 platforms:: |
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 * Built-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 [[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 12: | Line 37: |
| === driver name === | === MySQL for Python === |
| Line 14: | Line 39: |
| URL:: http://dustman.net/andy/python/MySQLdb/ licence:: platforms:: Python versions:: |
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 44: |
| ==== 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 46: |
| ==== Comments ==== | === mxODBC === |
| Line 23: | Line 48: |
| == Other Drivers == | 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 25: | Line 53: |
| === driver name === | mxODBC is compatible with the MySQL ODBC driver on Windows and Unix. |
| Line 27: | Line 55: |
| URL:: licence:: platforms:: Python versions:: |
=== pyodbc === |
| Line 32: | Line 57: |
| ==== Programming Model ==== | URL:: http://code.google.com/p/pyodbc License:: MIT Platforms:: Windows, Linux, MacOS X, FreeBSD, Solaris, Any (source provided) Python versions:: 2.4+ |
| Line 34: | Line 62: |
| ==== Comments ==== | 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:: https://launchpad.net/myconnpy License:: GNU GPL v2 Platforms:: Any (presumably) Python versions:: 2.4 or greater (not Python v3, yet!) * Implements the Python DB API 2.0 (PEP 249) * Pure Python implementation of the MySQL protocol. * Actively developed and maintained by Sun Microsystems, Inc. === mypysql === URL:: http://sourceforge.net/projects/mypysql/ License:: GNU GPL v3+ Platforms:: Any (presumably) Python versions:: 3 * This module provides (yet) incomplete PEP 249 functionality * C implementation of MySQL database connector * A majority of the commands are implemented * Still experimental but actively developed ---- |
| Line 38: | Line 94: |
| == Pros == == Cons == |
* [[Zope]] * A MySQL driver exists for [[PyDO]] (Python Data Objects) |
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
- Built-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 (not Python v3, yet!)
- Implements the Python DB API 2.0 (PEP 249)
- Pure Python implementation of the MySQL protocol.
- Actively developed and maintained by Sun Microsystems, Inc.
mypysql
- URL
- License
- GNU GPL v3+
- Platforms
- Any (presumably)
- Python versions
- 3
- This module provides (yet) incomplete PEP 249 functionality
- C implementation of MySQL database connector
- A majority of the commands are implemented
- Still experimental but actively developed