![]()
|
Next
Previous
Contents
1. IntroductionThis module should be mostly compatible with an older interface written by Joe Skinner and others. However, the older version is a) not thread-friendly (database operations could cause all other threads to block), b) written for MySQL 3.21 (does not compile against newer versions without patches), c) apparently not actively maintained. MySQLdb is a completely new module, distributed free of charge under the GNU Public License. 1.1 PlatformsLinux/UNIXThis module is developed on RedHat Linux (currently 7.1) for Intel. It
should build without much trouble on most platforms by using the
Windows (3.11, 95, 98, NT, 2000, CE, BSOD, XYZ, etc.)Windows is not a supported platform. However, the 1.2 PythonMySQLdb requires Python 1.5.2 or newer. Earlier versions will not
work, because support for C 1.3 MySQLMySQL-3.22Only versions 3.22.32 and up are guaranteed to work. Some older versions may work; if you have an older version you should seriously consider upgrading to get the bug fixes and particularly the security updates. MySQL-3.22 seems to have a problem trying to insert MySQL-3.23MySQL-3.23 is now stable (3.23.51 as of this writing). MySQLdb
supports transactions if the server supports them. Even then,
this does not guarantee that transactions will work. For that, you
must use a transaction-safe table (TST). Current TSTs are BDB and
InnoDB. Note that MySQL
generally operates in MySQL-4.0MySQL-4.0 is supported, though still alpha. 1.4 DateTimeIf you have the mx.DateTime package installed (recommended), MySQLdb will use it for date-related objects. Otherwise, these will be returned to Python as strings. You can also modify the type conversion dictionary to return these as other object classes, if you prefer. 1.5 MySQLmoduleMySQLmodule, the older MySQL interface by Joe Skinner and others, is
also a split C/Python interface. In contrast, MySQLdb's C portion,
1.6 Zope and ZMySQLDAI wrote a ZMySQLDA for use with MySQLdb. It's adapted from ZOracleDA from Digital Creations, makers of Zope. 1.7 DocumentationThe web page documentation may be slightly ahead of the latest release and may reflect features of the next release. 1.8 FAQsA FAQ is available at http://dustman.net/andy/python/MySQLdb/faq/MySQLdb-FAQ.html. Next Previous Contents |