I’ve been a bit slack about writing my MySQL thoughts of late. This would be caused by the fact that, as I write this, I’m now one week into a 12 month leave of absence from MySQL. Having given it much careful consideration, I’ve decided that the wisest way to survive the current economic problems… Continue reading Leaving MySQL (Not Really)
MySQL and Geospatial Data
MySQL has had basic support for Geospatial Data since 4.1, but has lacked some of the features of the OpenGIS specifications since then. The good news is, this is rapidly changing. Our own Holyfoot has been hammering away at WorkLog #1327, to provide precise functions for our GIS support. Even better, it’s fast. How fast?… Continue reading MySQL and Geospatial Data
WordPress Shouldn’t Use nofollow
In my random wandering across the internet today, I discovered that, by default, WordPress adds the rel=”nofollow” attribute to links in comments. Now, we all know the original purpose of nofollow, to try and discourage comment spam. This isn’t really relevant to WordPress anymore, though. Akismet has been supported in WordPress for quite some time.… Continue reading WordPress Shouldn’t Use nofollow
Open Database Alliance = Awesome
The big news coming from the MySQL Community today is that Monty Widenius and Percona have founded the Open Database Alliance, a group focused on “unifing all MySQL-related development and services, providing a solution to the fragmentation and uncertainty facing the communities, businesses and technical experts involved with MySQL”. I, for one, am 100% behind this.… Continue reading Open Database Alliance = Awesome
Don’t Forget to Alter your Federated Tables!
If you’re using the Federated engine, here’s something important to remember (apart from the usual advice of “please don’t”). If you need to change the structure of the remote table, always remember to update the Federated table. If not, when you try to use the table, you’ll get this error: mysql> SELECT * FROM foo;… Continue reading Don’t Forget to Alter your Federated Tables!