Accessing a MySQL database from python

Question

I have been trying for the past several hours to find a working method of accessing a mysql database in python. The only thing that I've managed to get to compile and install is pyodbc but the necessary driver is not available for ppc leopard.

I already know about this.

UPDATE:
I've gotten setuptools to install, but now MySQL-python won't build.

UPDATE: Now I've gotten sqlalchemy to install but while it will show up when called by the command line it won't import when used in my cgi script.

I tried MySQLdb and it won't compile. Also I wanted to avoid it being flagged as a duplicate. — GameFreak
– GameFreak, Commented Mar 7, 2009 at 2:15
Indeed. MySQLdb is the way to talk to MySQL from Python, and it does run fine on OS X. Google-guessing randomly, maybe this is your problem: whereofwecannotspeak.wordpress.com/2007/11/02/… — bobince
– bobince, Commented Mar 7, 2009 at 2:43
I already did that. And after fixing the errors with uint I've gotten the error: Traceback (most recent call last): File "setup.py", line 5, in <module> from setuptools import setup, Extension ImportError: No module named setuptools — GameFreak
– GameFreak, Commented Mar 7, 2009 at 2:49

Matthew Schinckel · Accepted Answer · 2009-03-07 04:06:18Z

2

Try SQL Alchemy.

It is awesome.

answered Mar 7, 2009 at 4:06

Matthew Schinckel

35.7k6 gold badges91 silver badges122 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

joeforker · Accepted Answer · 2009-03-07 02:33:31Z

1

Install fink. It includes the MySQLdb package.

answered Mar 7, 2009 at 2:33

joeforker

42.1k41 gold badges159 silver badges259 bronze badges

4 Comments

GameFreak Over a year ago

I see postgresql in there but not mysql.

GameFreak Over a year ago

I also tried macports but that started installing it's own version of mysql.

Jeremy L Over a year ago

Like most package managers, MacPorts is designed to offer a complete solution — not pieces.

joeforker Over a year ago

If you can't compile pieces of MySQL then let fink, macports etc. compile the whole thing for you. You don't actually have to use the extra bits. The library from that version will probably be able to talk to your database running in a different MySQL.

Catherine Devlin · Accepted Answer · 2009-04-02 14:30:53Z

UPDATE: Now I've gotten sqlalchemy to install but while it will show up when called by the command line it won't import when used in my cgi script.

Can you verify that the Python being invoked from your CGI script is the same as the one you get when you run Python interactively? Check which python and compare it to your webserver CGI settings. That's the only thing I can think of that would cause this - getting it installed in one Python but not the other.

What OS are you on? If you're on something like Ubuntu, sudo apt-get install python-mysqldb is much more reliable than trying to build it yourself.

Also, unless I'm mistaken, SQLAlchemy won't actually help you make the connection itself if you don't have a DB-API2 module (like python-mysqldb) installed - SQLAlchemy sits at the next level up, using the DB-API2 connection and making access to it more Pythonic.

Collectives™ on Stack Overflow

Accessing a MySQL database from python

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest