- Microsoft Windows chief decries standards grandstanding
- The 5 best, and 5 worst, features of Google Chrome OS
- Federal government using PS3 to crack pedophile passwords
- 10G Ethernet cheat sheet
- Top 10 free Windows tools for IT pros, at a glance
I've written about Twitter on and off over the last few weeks and it seems that interest and innovation in social media in general and Twitter in particular continues unabated.
To keep track of all of the Twitter applications and services that are appearing, about a month ago I started to compile a directory of Twitter stuff. This was going quite well (I was up to 224 outline entries) but then a few days ago reader Chris Miller (St. Louis, Mo.) wrote to tell me that he had noticed my "Twitter binge" and suggested that my obsession might be aided and abetted by his Twitter directory at EverythingTwitter.com.
Slideshow: 20 must-follow Twitter feeds
He's right. This Web site is a great compendium of all things twitterific and well worth exploring to see what tools and services might be valuable to you. I award EverythingTwitter.com a 5 out of 5 rating.
In the last Gearhead column that analyzed Twitter with Excel I offered readers a copy of the batch files and utility programs I had assembled to grab and analyze Twitter data. What I eventually sent out wasn't quite what I had planned. The system of batch files just wasn't up to the job, so in addition to cURL, I resorted to a suite of ugly little programs I wrote using FreeBASIC.
FreeBASIC is a free, open source BASIC compiler for Windows that is mostly QuickBasic-compatible and also provides features such as threading, operator overloading, function overloading and namespaces. FreeBASIC comes with an integrated development environment and, as a way to build quick and dirty tools, it's outstanding.
The only drawbacks are that it is Windows-only, sometimes produces diagnostic messages on programming errors that make little sense, and some of the documentation is incomplete. Bottom line: An excellent tool despite its minor shortcomings. I'll give FreeBASIC a rating of 4.5 out of 5 — definitely something to keep in your toolbox.
In my Excel/Twitter solution a main program takes the command-line arguments (these are a search term and start and stop dates) and calls a helper program for each date in the range specified.
This helper program, in turn, loops for as many as 500 "pages" of search results by executing a PIPE command using cURL. The PIPE lets cURL's output (the results of a Twitter search) be read by the helper program and parsed to count the number of Tweets returned (by searching for the string 'class="avatar"', only occurs in the user data associated with a Tweet … I did say it was ugly).
Comments (1)
Too much time on your hands...By Anonymous on May 21, 2009, 8:44 pmIt appears you haven't figured out that the signal to noise ratio on Twitster is too low to ever be a useful tool for people who like to understand rather than parrot.
Reply | Read entire comment
View all comments