python mysql interfacing
tvassila at siac.com
Sat Feb 8 22:46:43 CET 2003
Any one using python and mysql should seriously be considering snakedb
It can really make things easier, and also acts as a bridge keeping your
code database independent.
----- Forwarded by Thanos Vassilakis/SIAC on 02/08/2003 04:43 PM -----
<dbrady at computer.o To: python-list at python.org
Sent by: Subject: Re: python mysql interfacing
On Fri, 2003-02-07 at 10:29, vishnu mahendra wrote:
> is there a way in connecting python to mysql using mysql drivers.
> where can i find the drivers
Get the MySQLdb module. It's hard to find, harder to install, and
nigh-impossible to decipher. That said, getting Python to talk to your
MySQL database is so wonderful that it makes it all worth it. Google
for MySQLdb, and pick the sourceforge site.
Here's what worked for me, on a RedHat 8 system:
1. apt-get install MySQL-python. Getting the rpm didn't work (failed
dependencies without let or hindrance).
2. haul out Paul DuBois' book, "MySQL", and read the section on the C
3. cd to /usr/lib/python2.2/site-packages/MySQLdb/ and read the source
of connections.py and cursors.py.
Was it painful? Yes. Is there an easier way? I desperately hope so.
Once you get it, does it work? Yes.
Is it worth it? Oh my, yes. :-)
If anyone knows a less painful way of getting, setting up, and (still
relevant to my situation, even) finding documentation for the module,
I'd love to hear it.
dbrady at computer.org
There are 10 kinds of people in the world: those who understand binary
and those who don't.
This message and its attachments may contain privileged and confidential information. If you are not the intended recipient(s), you are prohibited from printing, forwarding, saving or copying this email. If you have received this e-mail in error, please immediately notify the sender and delete this e-mail and its attachments from your computer.
More information about the Python-list