Hiking the Kungsleden 2018

In late August to early September of 2018, I hiked Sweden’s 440km Kungsleden (Kings Trail) in the northbound direction. My buddy Emma came along and hiked a good two thirds of it too. I didn’t blog about it at the time but I did tweet each day as I went. Here are those tweets. I … Read more

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 now I’ve been using the in development versions of Spaz pulled from the GitHub repository … Read more

Issues with the YouGov poll on LD policies

Sunday’s YouGov voting intention poll for the UK contained a number of questions on policies. Commisioned by the Sun newspaper it seeks to gauge support for Liberal Democrat policies. Now as people (according to recent media reports) have been completely ignorant of the Liberal Democrat party for years and are only now becoming interested in … Read more

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 needed the records with the maximal value of x and the minimal value of y … Read more

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 edit the configuration and see where it’s put the APN and other connection info, and … Read more

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 if you don’t like the name you can change it. Just edit the preferences.json file … Read more

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 data than there were input columns | Warning | 1262 | Row 2 was truncated; … Read more

★ Ninjawords: iPhone Dictionary, Censored by Apple

Shared by Alan Apple come up with the most ridiculous reasons to keep competing software out of the hands of their users. Then, says Crosby: “We were rejected for objectionable content. They provided screenshots of the words ‘shit’ and ‘fuck’ showing up in our dictionary’s search results. What’s interesting is that we spent a good … Read more