Differences between revisions 1 and 21 (spanning 20 versions)
Revision 1 as of 2002-07-15 20:43:27
Size: 566
Editor: pD9EB03FC
Comment:
Revision 21 as of 2008-05-04 19:27:07
Size: 1479
Editor: c213-89-100-48
Comment: Changed python versions from 2.4 to 2.3 - 2.5 for "MySQL for Python".
Deletions are marked like this. Additions are marked like this.
Line 2: Line 2:
[[TableOfContents]]
Line 4: Line 3:
== Masthead == = MySQL =
Line 8: Line 7:
  platforms::   platforms:: Unix, win32
Line 10: Line 9:
== 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
  licence:: 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/
  Licence:: 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::

==== Programming Model ====

==== Comments ====
----
Line 38: Line 47:
== Pros ==

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

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.3 - 2.5

[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)

MySQL (last edited 2018-05-04 13:35:05 by DavidDLowe)

Unable to edit the page? See the FrontPage for instructions.