datasetsDb: A sample sqlite database

Description Usage Examples

View source: R/datasetsDb.R

Description

This database is bundled with the package, and contains all data frames in the datasets package.

Usage

1

Examples

1
2
3
4
5
6
7
8
library(DBI)
db <- RSQLite::datasetsDb()
dbListTables(db)

dbReadTable(db, "CO2")
dbGetQuery(db, "SELECT * FROM CO2 WHERE conc < 100")

dbDisconnect(db)

r-dbi/RSQLite documentation built on Oct. 21, 2018, 3:14 p.m.