MySQL and Python on Linux - Proper Method?

[Greg Fortune]

This is just my two cents, I'm deploying Python/Qt/MySQL solutions across 
Windows and Linux and MySQLdb is working very well.  The only thing I need 
that MySQLdb doesn't have done yet is native SSL encrypted connections and 
I have a tentative patch that should work.

As far as MySQLdb being dead, I agree that there hasn't been much activity 
but I don't see need for many changes either.  Bugs are virtually 
non-existent and the library is very capable.  Make sure that you grab the 
newest version (0.9.2) which is hosted on sourceforge.  I think the mysql 
docs list a really old version...

Greg Fortune
Fortune Solutions


Markus Wankus wrote:

> Hi all,
> 
> I am about to dive into my first Python/wxPython app on Linux using a
> MySQL
> database backend.  I was wondering what the proper way of doing this on
> Linux is.  I can currently see a couple of options:
> 
> 1) Using mxODBC (looks to be the most promising right now...)
> 2) Using MySQLdb (is this dead?) and probably SQLDict to make my life
> easier...
> 
> I'm sure there are kajillions (OK, maybe not kajillions but millions at
> least...) of Pythonistas doing this so I was curious as to what the
> accepted method of doing this is?  I am finding surprisingly little
> information on this subject.  Well, there is lots of info out there but it
> seems to be all over the map in terms of what the accepted method is.
> 
> I will ultimately be installing my *platform-independent* application on
> Windows machines as well.  I assume I will just be using an ODBC driver to
> connect to the MySQL database (running on a Linux server).
> 
> Thanks for any advice.
>