Differences between revisions 17 and 20 (spanning 3 versions)

MySQL

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

DB API 2.0 Drivers

MySQL for Python

URL: http://sourceforge.net/projects/mysql-python
licence: GNU General Public License (GPL), Python License (CNRI Python License), Zope Public License
platforms: OS Independent
Python versions: 2.4

[http://dev.mysql.com/downloads/python.html MySQL on-line documentation, additional forums] (maintainer does not currently read these)

mxODBC

URL: http://www.egenix.com/products/python/mxODBC/
Licence: 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.

Supported Python Applications

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

-  ⇤ ← Revision 17 as of 2007-06-16 01:22:50 → 
  Size: 988
  Editor: AndrewKuchling
  Comment:
+   ← Revision 20 as of 2008-02-18 17:45:34 → ⇥
  Size: 1473
  Editor: MarcAndreLemburg
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 3:
-[[TableOfContents]]
+= MySQL =
 Line 7:
-  platforms:: Unix, Win32
+  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 18:
+Line 32:
-   * [http://dev.mysql.com/downloads/python.html MySQL AB]: MySQL on-line documentation, additional forums (maintainer does not currently read these)
+[http://dev.mysql.com/downloads/python.html MySQL on-line documentation, additional forums] (maintainer does not currently read these)
-Line 20:
+Line 34:
+=== mxODBC ===
-Line 21:
+Line 36:
+  URL:: http://www.egenix.com/products/python/mxODBC/
  Licence:: 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.

----
-Line 23:
+Line 46:
-Line 25:
+Line 49:
-== Pros ==
 * Many administration tools from third parties
 * Fast

== Cons ==
 * Only '''very''' basic SQL support (entry level SQL 92). Many interesting features (subqueries, views, triggers, ...) are missing.
 * Some [http://sql-info.de/mysql/gotchas.html gotchas] (documented but unexpected features)

Page

User