Size: 803
Comment:
|
Size: 1194
Comment: Rearranged similar to the PostgreSQL page.
|
Deletions are marked like this. | Additions are marked like this. |
Line 2: | Line 2: |
[[TableOfContents]] | |
Line 4: | Line 3: |
== Masthead == | = MySQL = |
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:: GPL/Python license platforms:: Unix, win32 Python versions:: 1.5.2 thru 2.2 |
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 |
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: |
* several alternative cursor classes which can be used with cursor(cursorclass) on the connection object * additional methods info() and insert_id() in the cursor classes ==== Comments ==== == Other Drivers == === driver name === URL:: licence:: platforms:: Python versions:: ==== Programming Model ==== ==== Comments ==== |
---- |
Line 41: | Line 38: |
== Pros == == Cons == |
* ["Zope"] * A MySQL driver exists for ["PyDO"] (Python Data Objects) |
MySQL
- URL
- 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
- 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)