For some time now, I had a pending task of converting the latin1-encoded MySQL database powering this site into utf8. I finally managed to do it after getting some advice from the kind people at a Vienna WordPress meetup.
The essence is that out of all the methods suggested in the official documentation, what worked best for me was dumping all the data to a text file, marking up and encoding it as utf-8 in a text editor and then importing it into a new database (instead of working on the production DB) that we point the wp-config.php file to after everything is verified.
Last evening as I was listening Maxïmo Park (to get in the mood for their concert today), I found the song Apply Some Pressure quite interesting. I learned to play it on my guitar and analysed the harmony a bit. Here is my recording of the song (courtesy of my turbo webcam microphone 9000) with annotated chord progressions:
For today’s AFK activities I played a bit with recycling old stuff. You have an alarm-clock box you mean to throw away? Why not use it as a physical folder for small papers? I used mine as an organiser for inspirational flyers, booklets etc.
While strolling through a friend’s copy of The Economist today, admiring a very coherent visual identity they chose, I remembered reading this blog post about R having such a theme a while back.
Lead by curiosity, I gave it a try.
Blue makes for a soothing colour to present such shocking data, don’t you think?
Quick instructions… Continue reading
Want a nice GUI to read through your Twitter (and Facebook) feeds in Ubuntu?
While the official TweetDeck site doesn’t offer a native client and it is not possible to install it on top of Adobe Air anymore (since it’s been dropped), it is possible to get TweetDeck as a wrapped web app in Ubuntu – through Chromium’s “create application shortcuts”.
TweetDeck in Ubuntu – multiple columns show various feeds.