|
Size: 988
Comment:
|
Size: 1194
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 missing. * Some [http://sql-info.de/mysql/gotchas.html gotchas] (documented but unexpected features) |
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)