MySQL Connector/Python
launchpad.net
launchpad.net
Thanks so much!
(it's apparently been about for a year - yet i9n all my Googling I never came across it... :()
There is some C in there too - I haven't dug too deeply but I am guessing that certain core aspects will be in C for performance reasons.
EDIT: I apologise - I believed the Launchpad description which says Python/C. Checking the src it appears to be pure pure python. :)
Yep.
The benchmarks will be interesting. If they managed to get good performance out of this then I'll be most impressed.
I'd be surprised if there were any performance loss compared to the amount of time required to marshal Python data for calls via the C library.
Really? How so?
mysql client must be installed on every machine
mysql python bindings must be compiled and deployed on every machine.
I imagine it's not uncommon among Python web apps for the mysql library to be the only thing that requires gcc to compile from source. Having a library entirely in python, for which you presumably already have a deployment process, would definitely simplify things.
How did you get python on the machine in the first place? Any distribution worth using for LAMP already provides everything you need for a base install for this already compiled and packaged.
Pure <your favorite language> implementations are useful from a portability, testing/verification, and avoiding vendor lock-in perspective, but the problem of "How do I get the libraries I need on all the machines" has long since been solved. In fact, using a packaging system like dpkg or rpm will make it easy to determine if you're missing anything, since they can list everything that is installed via packages.
Windows isnt too bad because there is Windows binaries that do work ok. But on Linux the current offerings of MySQL in Python have always been a bit shaky.
For an end point software package it's a little too unreliable for us to, well, rely on :)
This looks so much promising.