In sctyner/dplyr050: A Grammar of Data Manipulation

Vagrant set up

Run this code to set up databases on vagrant vm. https://gist.github.com/trestletech/b5babf76487fa6c898b2

# Install needed apt packages
sudo apt-get install postgresql libpq-dev
sudo apt-get install mysql-server libmysqlclient-dev

# Set up database users
sudo su -
sudo -u postgres createuser --superuser Ruser
sudo -u postgres psql
\password Ruser
# press enter twice
# Ctrl + D

mysql -u root -p -e "CREATE DATABASE lahman;"
mysql -u root -p -e "CREATE DATABASE nycflights13;"
mysql -u root -p -e "CREATE DATABASE test;"

sudo -u postgres createdb lahman
sudo -u postgres createdb nycflights13
sudo -u postgres createdb test
# Ctrl + D

R
install.packages(c("RPostgreSQL", "RMySQL"))
# Ctrl + D

library(dplyr)
lahman_mysql()
lahman_postgres()
nycflights13_postgres()

sctyner/dplyr050 documentation built on May 17, 2019, 2:22 p.m.