So, Python is cool. Its many modules, like MySQL-python, are not cool. Compared to CPAN they stink. (No offense, developers! You are doing your best–just there aren’t as many Python hackers as Perl hackers.)
To interface with MySQL in Python with the “MySQL-Python” module is to use the MySQL C API. W00t.
I toyed with Jython, Python totally implemented in Java. It was pretty awesome to run Java from Jython, like
from java import awt
class SpamListener(awt.event.ActionListener):
def actionPerformed(self,event):
if event.getActionCommand() == "Spam":
print 'Spam and eggs!'
f = awt.Frame("Subclassing Example")
b = awt.Button("Spam")
b.addActionListener(SpamListener())
f.add(b, "Center")
f.pack()
f.setVisible(1)
(taken from Subclassing Java Classes in Jython).
Jython is depressing too, though, because its last Python implementation was for version 2.1. Python’s on, like version 2.4 now. 2.1 came out a bunch of years ago.