Differences between revisions 11 and 12
Revision 11 as of 2005-05-18 08:15:26
Size: 1401
Editor: 222
Comment:
Revision 12 as of 2005-05-18 08:16:22
Size: 1404
Editor: 222
Comment:
Deletions are marked like this. Additions are marked like this.
Line 30: Line 30:
  URL::http://sourceforge.net/projects/mysql-python
  licence::GNU General Public License (GPL), Python License (CNRI Python License), Zope Public License
  URL:: http://sourceforge.net/projects/mysql-python
  licence:: GNU General Public License (GPL), Python License (CNRI Python License), Zope Public License
Line 33: Line 33:
  Python versions::2.4   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

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

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.