Differences between revisions 1 and 33 (spanning 32 versions)

MySQL

URL: http://www.mysql.com/
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: 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

MySQL on-line documentation, additional forums (maintainer does not currently read these)

PyMySQL

URL: http://www.pymysql.org/
License: MIT
Platforms: OS Independent, CPython 2.x and 3.x, PyPy, Jython, IronPython
Python versions: 2.4 - 3.2

Pure-Python focused on simplicity and compatibility
Virtually 100% compatible with MySQLdb
Good performance

mxODBC

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

mxODBC is compatible with the MySQL ODBC driver on Windows and Unix.

pyodbc

URL: http://code.google.com/p/pyodbc
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: https://launchpad.net/myconnpy
License: GNU GPL v2
Platforms: Any (presumably)
Python versions: v2.4 to v2.7 and Python v3.1

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

Supported Python Applications

Zope
A MySQL driver exists for PyDO (Python Data Objects)
Python - MySQL Websites

-  ⇤ ← Revision 1 as of 2002-07-15 20:43:27 → 
  Size: 566
  Editor: pD9EB03FC
  Comment:
+   ← Revision 33 as of 2011-08-05 19:49:34 → ⇥
  Size: 3504
  Editor: 116
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 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 ====
+=== PyMySQL ===
-Line 23:
+Line 48:
-== Other Drivers ==
+  URL:: http://www.pymysql.org/
  License:: MIT
  Platforms:: OS Independent, CPython 2.x and 3.x, PyPy, Jython, IronPython
  Python versions:: 2.4 - 3.2
-Line 25:
+Line 53:
-=== driver name ===
-Line 27:
+Line 54:
-  URL::
  licence::
  platforms::
  Python versions::
+ * Pure-Python focused on simplicity and compatibility
 * Virtually 100% compatible with MySQLdb
 * Good performance
-Line 32:
+Line 58:
-==== Programming Model ====
+=== mxODBC ===
-Line 34:
+Line 60:
-==== 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

mxODBC is compatible with the MySQL ODBC driver on Windows and Unix.

=== pyodbc ===

  URL:: http://code.google.com/p/pyodbc
  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:: https://launchpad.net/myconnpy
  License:: GNU GPL v2
  Platforms:: Any (presumably)
  Python versions:: v2.4 to v2.7 and Python v3.1

 * 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 106:
-== Pros ==

== Cons ==
+ * [[Zope]]
 * A MySQL driver exists for [[PyDO]] (Python Data Objects)
 * [[http://www.runmapglobal.com/blog/how-to-create-web-pages-and-websites/ | Python - MySQL Websites]]

Page

User