Differences between revisions 10 and 11
Revision 10 as of 2003-11-19 18:12:53
Size: 1159
Editor: MikeRovner
Comment: link to mysql gotchas added
Revision 11 as of 2005-05-18 08:15:26
Size: 1401
Editor: 222
Comment:
Deletions are marked like this. Additions are marked like this.
Line 28: Line 28:
=== 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

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

MySQL for Python

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.