DataFest example (part 1: accessing and saving the data)
========================================================
Nicholas Horton, nhorton@amherst.edu, March 26, 2014
------------------------------------------------------

#### Accessing the data

```{r,eval=TRUE}
require(RMySQL)
con = dbConnect(MySQL(), user="mth292", host="rucker.smith.edu", password="RememberPi", dbname="airlines")
```

```{r}
ds = dbGetQuery(con, "SELECT DayofMonth, Month, Origin, Dest, ArrDelay FROM ontime WHERE Year=2007 AND Origin='BDL'")
save(ds, file="PREPROCESSED")
```
#### Other one-time only data manipulation can be done here.

#### Now we can run another R Markdown file to read this in (and save time!)