Any R nerds with Stat1 access: Stat1 now has the RMySQL package installed.
What this means is the following; if you have something from the db you
want to analyse, there's no need to faff around on the command line or
inside MySQL to manually export it as a file, import it into R, analyse it,
and then leave a big juicy TSV around for people to poke at when they're
bored. You can run SQL queries against the slaves from inside R, and have
these queries and associated data fall off and die as soon as you close the
session or run rm(). It's also good for replicability, since people will
now (largely) be able to retrieve the same data and run the same analysis
using a single script. Thanks to Jeff Green and Andrew Otto for getting it
up and running :).
--
Oliver Keyes
Community Liaison, Product Development
Wikimedia Foundation
Show replies by date