lahman: Cache and retrieve an 'src_sqlite' of the Lahman baseball...
In sctyner/dplyr050: A Grammar of Data Manipulation

This creates an interesting database using data from the Lahman baseball data source, provided by Sean Lahman at http://www.seanlahman.com/baseball-archive/statistics/, and made easily available in R through the Lahman package by Michael Friendly, Dennis Murphy and Martin Monkman. See the documentation for that package for documentation of the inidividual tables.

lahman_sqlite(path = NULL)

lahman_postgres(dbname = "lahman", ...)

lahman_mysql(dbname = "lahman", ...)

lahman_df()

lahman_dt()

copy_lahman(src, ...)

has_lahman(type, ...)

lahman_srcs(..., quiet = NULL)

`...`	Other arguments passed to `src` on first load. For mysql and postgresql, the defaults assume you have a local server with `lahman` database already created. For `lahman_srcs`, character vector of names giving srcs to generate.
`type`	src type.
`quiet`	if `TRUE`, suppress messages about databases failing to connect.

# Connect to a local sqlite database, if already created

if (has_lahman("sqlite")) {
  lahman_sqlite()
  batting <- tbl(lahman_sqlite(), "Batting")
  batting
}

# Connect to a local postgres database with lahman database, if available
if (has_lahman("postgres")) {
  lahman_postgres()
  batting <- tbl(lahman_postgres(), "Batting")
}