The second project which I started is a small, Rails-based, web-app to backup and visualize my own tweets. You can find the source code at GitHub in the twitter_backup-repository. As the search-feature of Twitter doesn’t allow you to search in old tweets and there is no way to scroll back in your own timeline this felt like a good idea. The tool grabs all my tweets and the retweets I’ve done and saves them locally. Using the web-frontend of twitter_backup you can scroll through your own timeline, see how much you interact with other users and find out on which days of the week and which times you most frequently tweet. Additionally the locations of your tweets are saved as well and you can find out from which places you most often tweet. And the biggest advantage of your own tweet-backup is also implemented: A working search-feature, which is done using Solr. You can search for users, specific dates or just the content of a tweet, which makes it much easier to find those interesting link you are sure you’ve tweeted but can’t find again on Twitter itself.
The general visualization is done using the Google Chart Tools and the mapping of the locations, along with the heat-maps are rendered through the Google Maps API and heatmap.js. If you’re interested in trying the small tool you can find my own setup on The Phylomemetic Tree.