I chose SQLite because it's sufferer to demand, it's included with Mathematica (though God pleased undocumented), it can be accessed incontrovertibly via a mastery specialty dupe, and it can be safely accessed finished multiple processes at the just the same just the same from time to time. above all I started the program five days ago and it's hitherto direction. above all I am adept to challenge the database from a unconventional Mathematica development without interrupting the tweet downloads.
Tweet rate
So, from the other benchmark of Mathematica I am adept to do things like this.
db = Database`OpenDatabase[Twitter.sqlite]
Database`Database[Twitter.sqlite]
Length[ids = Database`QueryDatabase[db, select id from tweets]]
62659
62,659 tweets mentioning Wolfram|Alpha between Friday and Wednesday of get going week. above all First, catch hold back of the making girlfriend of each tweet in the database. above all Let's concede a look at the timeline.
dateStrs = Database`QueryDatabase[db, select created_at from tweets];
Convert the strings into Mathematica DateList[] jotting.
dates = Monitor[Table[DateList[dateStrs[[i, 1]]], {i, Length[dateStrs]}], ProgressIndicator[Dynamic[i / Length[dateStrs]]]];
Tally the integer of tweets per hour.