Using SQLAlchemy unit test cases to further develop MySQL Connector/Python. It’s probably debatable whether that’s a good method or just lame. But it sure helps lots! We’ve been pushing some code past days that makes Connector/Python almost pass all tests. Well, 4% is still failing, but I’m confident that in a few most problems will be dealt with. I had to make some changes to the SQLAlchemy v0.6 dialect as well, and some test cases had to be corrected.

FOSDEM 2010, Sunday 7 February, the MySQL Developer Room packed with 12 talks! And this year we serve Python just before the lunch break. In 20 minutes I’ll try to give an overview of the drivers currently available for connecting your Python applications with MySQL. Incase you wonder, this will not evolve around MySQL Connector/Python alone! We’ll also go over some frameworks and tools like SQLAlchemy. 20 minutes, it’s not much, but should be enough.

Last week I took SQLAlchemy v0.6 out of its trunk and tested it again with our MySQL Connector/Python. And surprise! SQLAlchemy comes with a ‘dialect’ supporting it! Nice! However, we’re still a long way on making it work. I found some additional problems which need to be fixed first. $ nosetests --dburi=mysql+mysqlconnector://root:@localhost/sqlalchemy \ test/dialect/test_mysql.py.. Ran 32 tests in 4.507sFAILED (errors=6, failures=1) Oh, there were more errors and failures and all that due to bugs in MySQL Connector/Python.

A few days ago MySQL 5.1.42 got released and it is now available with builds for MacOS X 10.6 (Snow Leopard)! The download website doesn’t show it yet, but if you are burning to try, you can get it from the mirror-picking-website. As usual, don’t forget to checkout the changelog before upgrading! If you want to compile it yourself, and need a universal binary, you could try my previous blog entry «Building MySQL universal binaries using MacOS X 10.

Saturday 2 January, 13:05 CET: “This is your captain speaking. We are ready to start but we’ll have to wait another 5 to 10 minutes because a bag was apparently loaded to much. Security regulations say we have to get it off the plane.” Fair enough, the passengers were silently agreeing.20 minutes later, the voice from the cockpit brought some update, which really wasn’t one: “Bag not found yet..” A few passengers, including me, were already getting annoyed, some a bit angry.