Category Archives: Geekery

My very own twitter client.

Followers on Twitter may have noticed that I’m now posting using a client called alanjames. This is really just Spaz but now registered at Twitter under my own name. Here’s the how and why I’ve done that. For some months … Continue reading

Posted in Geekery | 2 Comments

Within-group aggregates with another wrinkle.

Recently when optimising an SQL query I needed to return a specific subset of records from a large table. The brilliant Common Queries Tree pointed me in the right direction, but the examples didn’t quite cover my specific case. I … Continue reading

Posted in Geekery | Tagged | Leave a comment

Tethering Jolicloud with a Nokia 6500 Classic

Yesterday I plugged my Nokia 6500 Classic phone into my Jolicloud powered netbook, told the network manager I was on a Vodafone contract and bang, instant 3G internet access. It could hardly be simpler. Once its set up, you can … Continue reading

Posted in Geekery | 1 Comment

Spaz, the twitter client.

I use a Twitter client named Spaz. Now if you’re from the UK the name might strike you as being a bit distasteful, perhaps even offensive. Get over it, its just a random sound in most of the world. Actually … Continue reading

Posted in Geekery | Leave a comment

MySQL: Row N was truncated; a solution

You’re importing some data into MySQL and using LOAD DATA INFILE so you can do a SHOW WARNINGS afterwards. Every line of your import file has a warning: | Warning | 1262 | Row 1 was truncated; it contained more … Continue reading

Posted in Geekery | Tagged | 26 Comments