Differences between revisions 13 and 14
Revision 13 as of 2007-06-16 00:46:28
Size: 1406
Comment: mysql-python is the current version
Revision 14 as of 2007-06-16 00:47:14
Size: 1268
Comment: Remove template
Deletions are marked like this. Additions are marked like this.
Line 35: Line 35:

=== driver name ===

  URL::
  licence::
  platforms::
  Python versions::

==== Programming Model ====

==== Comments ====

TableOfContents

Masthead

URL

http://www.mysql.com/

licence
GPL
platforms
Unix, win32

DB API 2.0 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

Other 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

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.