Installation: > install.packages("RMySQL", dependencies = TRUE) > library(RMySQL) Simple usage: > con <- dbConnect(MySQL(), user="msandbox", password="msandbox", dbname="sakila", host="127.0.0.1", port=5527) > dbGetQuery(con, "select * from sakila.sales_by_store") store manager total_sales 1 Woodridge,Australia Jon Stephens 33726.77 2 Lethbridge,Canada Mike Hillyer 33679.79 > sales_by_film_category <- dbReadTable(con, "sales_by_film_category") > qplot(category, total_sales, data=sales_by_film_category, geom="bar", fill=category)</p> </code>...

Basic idea: https://github.com/fipar/playground/blob/master/console_graphs/hello.c Goals: support streams use \220 and \223 to support finer granularity on the same # of rows  

Repo: https://github.com/fipar/vagrant_mysql_workshop_2013 Base: https://github.com/fipar/vm_host_config/tree/master/vms/percona-server-5.6 Additional provisioning: wget https://launchpad.net/test-db/employees-db-1/1.0.6/+download/employees_db-full-1.0.6.tar.bz2 tar xjvf employees_db-full-1.0.6.tar.bz2 && rm -f employees_db-full-1.0.6.tar.bz2 cd employees_db mysql -t < employees.sql wget http://downloads.mysql.com/docs/sakila-db.tar.gz tar xzvf sakila-db.tar.gz && rm -f sakila-db.tar.gz mysql < sakila-db/sakila-schema.sql mysql sakila < sakila-db/sakila-data.sql

I am adding a Notes category to this blog, for 'lab' style notes that are mostly meant for self-consumption. I am making this public because it makes it easier for me to collaborate, and maybe some of the content ends up being useful to a wider audience.