Differences between revisions 18 and 19
Revision 18 as of 2007-07-14 20:10:34
Size: 1060
Editor: port64
Comment:
Revision 19 as of 2008-02-01 18:28:57
Size: 1194
Editor: PaulBoddie
Comment: Rearranged similar to the PostgreSQL page.
Deletions are marked like this. Additions are marked like this.
Line 3: Line 3:
[[TableOfContents]] = MySQL =
Line 7: 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:
----
Line 23: Line 37:
Line 25: Line 40:

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

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)


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.