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. 14, 2019, 11:20 p.m.