Python and MySQL

[Hrvoje Niksic]

Do people use Python connected to MySQL?  If so, what client do you
use?  I've seen two, the MySQLdb, and the generic mxODBC.  The latter
seems better, but I was unable to compile the required infrastructure, 
i.e. the myodbc libraries.  What are the experiences of others?

I ask this because I will soon start working for a company that
connects Perl with Microsoft SQL server extensively.  (They connect
through, I think, Sybase ODBC drivers.  I could be wrong.)  I would
like to gradually convert their infrastructure to more maintainable
Python, so I'm using MySQL for practice.

If there are useful experiences or cautionary tales regarding mxODBC
and MSSQL/Sybase, I'd like to hear them too.