Few days ago, the folks at SQLAlchemy pushed some proposed modification to the MySQL Connector/Python dialect. Before this patch, previous report yielded 72 errors and 11 failures. Now we got down to 9 errors, but the failures are still lingering. Is this an improvement? Yes and no, failures should go down, but there are some SQLAlchemy tests I just can’t figure out, yet.. clues are welcome! Here are some detailed results which also included MySQLdb and oursql.
Stuffing the gaps in the COLLATIONS table using a stored procedure
To far fetched (pun inteded), some might think.. Below you’ll find a procedure to get a list of MySQL supported character sets and their collations. The output is Python and can be used to build a (big) tuple. The problem is that character set IDs in MySQL have ‘gaps’. For example hebrew has ID 16, and the next character set in the COLLATIONS-table, tis620, has ID 18. Not a big problem, just a bit annoying.
First trials of benchmarking MySQL/Python DB interfaces
Is there a performance penalty using a pure Python database interface? Yes there is. But how much? .. also depends on who wrote it. I started implementing some benchmarking for MySQL Connector/Python. Main reason is to identified bottlenecks or just plain bad coded. Another reasons: it’s cool and the question was raised during my talk at FOSDEM and also online. Oh, yes, MySQL Connector/Python ain’t fast right now. Just compare a script spawning 10 threads opening 1000 connections.
Change of website causes a bit of havoc
Yesterday, my new website went online and it caused a bit of problems with aggregators. My old domain was set to redirect to my new website, but left my old website with blog entries. That’s now fixed. New website is http://geert.vanderkelen.org. No ads, completely on Blogger. This way I can eventually get rid of my ‘root’ server and reduce costs. Sorry for the noise.
My sessions at the MySQL Conference & Expo 2010
A preliminary schedule is now available for the MySQL Conference & Expo 2010 (in Santa Clara, California, USA). I have two talks and a tutorial, currently scheduled as follows: MySQL Cluster Tutorial, Mon 08:30 on 12 Apr 2010, together with Andrew Hutchings and Andrew Morgan MySQL Cluster: An Introduction, Tue 11:55 on 13 Apr 2010 Connecting MySQL and Python, Tue 15:05 on 13 Apr 2010 Schedule might change a bit, so I suggest keeping an eye on the conference website.