To test it I used the access logs I was exploring lately. I created a view, 'hitsperminute' on the database containing the hits per minute on free-penguin, as the name suggests. Adding database connectivity to R was no fuzz at all. It just worked. Consider the following code:
con <- dbConnect(dbDriver("MySQL"), dbname = "webstats", password="*****", username="dbuser")
a <- dbGetQuery(con, paste("SELECT * FROM hitsperminute;"))
main="Free Penguin News Quake",
sub="free-penguin.org requests per minute from Jan 2nd to Jan 8th 2006")
the result is this recent one, but skipping manual steps. Scripts like this are fully batch mode enabled. One could run it on http requests for example. Cool, ain't it?
Commenting is closed for this article.