It is possible to module written purely in Python that will permit a script to talk with a MySQL database? I have already attempted MySQLdb with no success. It takes an excessive amount of: GCC, zlib, and openssl. I actually do not need these power tools even when Used to do, I'd rather not spend your time keeping them interact. I am searching for tools that can make my work simpler.

Can someone point me in direction of a MySQL Python module designed in Python? Otherwise, tips about writing my very own code for interacting with MySQL could be appreciated.

Thanks,

Tony

There is a project at Sun to implement 100% python mysql driver.

https://launchpad.net/myconnpy

I've not found any code for this though. But based on a blog comment, it's a lot more than vaporware.

Recently there's also oursql (docs), that has various advantages over MySQLdb along with other existing motorists -- listed towards the top of the documentation.

You'll find pre-built binary packages for MySQLdb and it is dependencies for many os's.

http://sourceforge.net/project/showfiles.php?group_id=22307&package_id=15775

What platform are you currently running on?

You've checked out these?

http://wiki.python.org/moin/MySQL

Thanks everybody for the solutions. Since I am using a small database (a couple of hundred records, mainly names and addresses) I have made the decision to make use of SQLite. I simply discovered it. It appears to become perfectly suited to my reasons it had been easy to install (required about two minutes) and utilizes Python. I am tied to Python 2.4 and so i can't make use of the sqlite3 module, but I am able to talk with the database by utilizing Python's 'subprocess.Popen' function and command-line parameters.

Certainly MySQLdb is the greatest solution, but when you cannot use it…

For those who have libmysqlclient.[sodll], you can can get on directly using ctypes module.

As pointed out in earlier answer, MySQL Connector/Python implements the MySQL Server/Client completely in Python. No producing, just setting up.

Listed here are the hyperlinks:
* https://launchpad.net/myconnpy
* code: https://code.launchpad.net/myconnpy
* download: https://launchpad.net/myconnpy/+download (development shapshots)

It isn't complete yet, however it must have enough to help keep you going. (FYI, I'm the maintainer)

So far as I understand there's no direct alternative. The only real factor I'm able to think about is by using ODBC rather, via pyodbc. The MySQL site comes with an ODBC connector you are able to download. But I have not used at all this method myself, and so i can't say how good it'll work.