Best Resource for mysql + python 2.6 programming

Question

I need a great resource for interacting with MySql (version 5.0.45) with Python2.6.

I'm using cherrypy, mako, the standard library, and nothing else.

The resources can be blogs, howtos, books (online of offline), whatever.

Additional information:

The python mysql module, MySQLdb, is compatible with Python DB-API 2.0 . See http://sourceforge.net/projects/mysql-python.

Answer 1

Python connectivity to DBs is accomplished (most of the times) through the DBI (Python Database API). The Python DBI has 2 versions and their documentation is the place for you to start: v.1 and v.2. You must check what version is supported by the MySQL connector and use the corresponding spec version.

For more details about Python and MySQL, you can find good articles on Using MySQL With Python and here is the article that walks you through most of the operations: Writing MySQL Scripts with Python DB-API

./alex

Answer 2

MySQL and Python discussions: http://forums.mysql.com/list.php?50

Answer 3

Can anyone tell me where we can get python2.6 for Windows supported MYSQL egg or installation. from tar file I tried to install, I get an error vcvarsall.bat not found etc. I believe I am using Python and not VisualStudio. Why can't we have an independant install for MYSQL rather than depending on stuff

Cheers! Rahul