Differences between revisions 1 and 25 (spanning 24 versions)

MySQL

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

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: 2.3 or greater

Supported Python Applications

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

-  ⇤ ← Revision 1 as of 2002-07-15 20:43:27 → 
  Size: 566
  Editor: pD9EB03FC
  Comment:
+   ← Revision 25 as of 2009-10-04 04:35:01 → ⇥
  Size: 2035
  Editor: pool-71-244-17-214
  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:
-[[TableOfContents]]
-Line 4:
+Line 3:
-== Masthead ==
+= MySQL =
-Line 7:
+Line 6:
-  licence:: GPL
  platforms::
+  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 [[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::
  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 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:
-==== Comments ====
+=== mxODBC ===
-Line 23:
+Line 36:
-== 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 41:
-=== driver name ===
+mxODBC is compatible with the MySQL ODBC driver on Windows and Unix.
-Line 27:
+Line 43:
-  URL::
  licence::
  platforms::
  Python versions::
+=== pyodbc ===
-Line 32:
+Line 45:
-==== 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 50:
-==== 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.3 or greater

----
-Line 38:
+Line 65:
-== Pros ==

== Cons ==
+ * [[Zope]]
 * A MySQL driver exists for [[PyDO]] (Python Data Objects)

Page

User