[Tutor] MySQL and Python

[Danny Yoo]

On Mon, 29 Oct 2001, Pijus Virketis wrote:

> I wish to write a Python and MySQL script, which will run on my ISP's
> server. After checking the Database SIG on python.org, I gathered that one
> needs the <MySQLdb> module (http://sourceforge.net/projects/mysql-python)
> to be installed in order to be able to access a MySQL database from Python.
> My ISP does not have that module installed, and asked me to provide more
> information about it. Before I send those guys off installing software on
> their server, I just want to make sure if this really is the prefered/real
> way of doing things? Is there some general DB API I can use instead that
> comes with basic Pyhon?

Yes, the MySQLdb module by Andy Dustman,

    http://dustman.net/andy/python/MySQLdb

is the module you'll want if you want to work with Python and MySQL.


MySQLdb follows the conventions that most Python database modules follow,
the "DB-API 2.0":

    http://www.python.org/topics/database/DatabaseAPI-2.0.html

and so you can use the functions in the API.

Hope this helps!