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.
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”.
Doing some web design these days, I find that Ubuntu offers a really mature stack to tackle the job with powerful applications and good OS integration. Drag’n’drop a wide spectrum of objects between applications to avoid having to browse through your files, multiple desktops to reduce window chaos and the do-one-thing-but-do-it-right philosophy stemming from the terminal era and general speed are some of the advantages that you notice quite quickly as really helpful. I’ll shortly cover some of the apps I use and their best features.
For the initial concept forming I use:
Shotwell – great for importing & organizing “inspiration” photographs; tags and grades really help a lot and it’s cool to be able to quickly colour-balance, straighten and crop photos
Nautilus – with its multiple tabs, split windows and drag’n’dropability of files, folders, & bread crumbs, it is an essential helper throughout the whole process (the dash is also a good sidekick with quick search capabilities for far-away files and apps)
As I went searching for an RStudio equivalent for Python I discovered IPython notebook, which I shortly described in this Stack Overflow answer:
IPython has a really cool sub-project called IPython notebook. It basically allows you to interactively code and document what you’re doing in one interface and later on export it as a notebook or script or print it as static html (and therefore pdf as well).
It starts a web application locally and you use it from your browser.