§calcwars twitter book.

Another week, another hack-day. And another book made from twitter feeds. I was so pleased with the hardback version of my twitter book that I knew I had to make another book. And quickly. At the Warblecamp hackday last Saturday/Sunday I set about making book from one of the twitter events I’d been following. The [...]

My twitter book-making project

In other news, I made a book. A book of all my tweets since December 2007. I’m still not sure what I think about the exercise. Twitter’s the closest thing I have to a diary. I’ve never tweeted specifically in order to make a daily record, but that’s the form I chose for the book. [...]

Sucking tweets into a local database

A friend asked me yesterday if I could snap together a script to build a local database of tweets using the twitter search API. This is what I came up with. The script takes one argument – the term to search on – and creates a sqlite3 database in the current directory containing all the [...]

List of UK MPs on twitter

I just spent several hours building a list of MPs on twitter by harvesting, cross-tabulating and advanced munging of various lists on twitter. Yes, I know it’s already been done by tweetminster and there are lists on listorious, probably elsewhere too. But there are none that I know of that are freely available, which are [...]