2009 was a special year, but 2010 top it: marrying Marta and the birth of our son Tomas. I have what I wished for, now I know who and what to work for. (picture removed)
MySQL v5.5 and Python
MySQL v5.5 is GA, but is it working with Python? Yes, it does. Below you’ll find some quick, small tests I did with MySQLdb, oursql and our own MySQL Connector/Python. My desktop is a Mac, but when it works on that, I’m sure it works elsewhere too. If not, just let us know! MySQL for Python (aka MySQLdb) Installing MySQL v5.5.8 64-bit from tar ball on MacOS X 10.6, it compiled fine and the module loaded giving me the expected result:
This blog served by MySQL v5.5
MySQL v5.5 is GA and my blog, using Wordpress 3.0, runs on it. My personal highlight of this new MySQL version? The fact that it is released by Oracle.
MySQL Connector/Python 0.3.0 has been released!
MySQL Connector/Python 0.3.0, a development release, is available for download: https://launchpad.net/myconnpy/+download Since version 0.3.0 is still a development release, or ‘alpha’, it is not recommended to run this in production. MySQL Connector/Python 0.3.0 adds following features: Python v2.4 support is back. Support for compressed protocol. Support for SSL connections (when Python’s ssl module is available). Support for packets which are bigger than 16MB. Max allowed packetsize defaults to 1GB. Some performance improvements.
Query caching with MySQL Connector/Python
This blog post shows how to create a cursor class for MySQL Connector/Python which will allow you to cache queries. It will hold the query itself and the result in a global variable. Note: this is a proof of concept and is only meant as a demonstration on how to extend MySQL Connector/Python. Why query caching? You are doing lots of queries that have the same result. It would be expensive to always run the same exact query.