Install RSQLite with, e.g.
install.packages("RSQLite", depends = TRUE)
(pick a repository from the list that is close to you.)
con <- dbConnect(dbDriver("SQLite"), "~/baseball2.db")
dbListTables(con)
x = dbGetQuery(con, ""SELECT DISTINCT yearID from Teams")
Duncan Temple Lang
<duncan@wald.ucdavis.edu>
Last modified: Tue Jul 15 09:32:28 PDT 2008