Differences between revisions 6 and 10 (spanning 4 versions)
Revision 6 as of 2002-08-15 16:53:20
Size: 1060
Editor: 216
Comment:
Revision 10 as of 2003-11-19 18:12:53
Size: 1159
Editor: MikeRovner
Comment: link to mysql gotchas added
Deletions are marked like this. Additions are marked like this.
Line 12: Line 12:
=== driver name === === MySQLdb ===
Line 45: Line 45:
 * Fast
Line 48: Line 49:
 * Some [http://sql-info.de/mysql/gotchas.html gotchas] (documented but unexpected features)

TableOfContents

Masthead

URL

http://www.mysql.com/

licence
GPL
platforms
Unix, win32

DB API 2.0 Drivers

MySQLdb

URL

http://dustman.net/andy/python/MySQLdb/

licence
GPL/Python license
platforms
Unix, win32
Python versions
1.5.2 thru 2.2

Extensions to DB API

  • 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

Supported Python Applications

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

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 (last edited 2018-05-04 13:35:05 by DavidDLowe)

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