Returns a local database connection. This corresponds to a DBI-compatible DuckDB database.

usitcgravity_connect(dir = usitcgravity_path())

Arguments

dir

Database location on disk. Defaults to the usitcgravity directory inside the R user folder or the USITCGRAVITY_DIR environment variable if specified.

Examples

if (FALSE) {
 DBI::dbListTables(usitcgravity_connect())

 DBI::dbGetQuery(
  usitcgravity_connect(),
  'SELECT * FROM usitcgravity WHERE year = 2010'
 )
}