Differences between revisions 9 and 10
Revision 9 as of 2003-01-31 00:30:53
Size: 1065
Editor: adeskout
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 49: 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.