Using local filesystem database RSQLite::SQLite()

oh_con(
  path_db = system.file("offhab.duckdb", package = "offhabr"),
  read_only = T
)

Arguments

path_db

path to database file, defaults to duckdb in this R package

read_only

only applicable to duckdb (not SQLite); defaults to TRUE; vs set to FALSE if writing to database

Value

a DBI::dbConnect() object

Examples

if (FALSE) {
con <- oh_con()
DBI::dbListTables(con)
}