Creates an isolated DuckDB database handle, opens a DBI connection, and
loads the extension bundled with Rducksassy. The database handle permits
unsigned extensions because locally built DuckDB extensions are not signed.
Usage
rducksassy_connect(dbdir = ":memory:", read_only = FALSE, config = list(), ...)
Arguments
- dbdir
Database file path or ":memory:".
- read_only
Open an existing database without write access.
- config
Named DuckDB configuration values.
- ...
Additional arguments passed to duckdb::duckdb().
Value
A live DuckDB DBI connection. Disconnect it with
DBI::dbDisconnect(con, shutdown = TRUE).
Examples
con <- rducksassy_connect()
DBI::dbGetQuery(con, "SELECT sassy_contains('ACGT', 'TTACGT', 0)")
DBI::dbDisconnect(con, shutdown = TRUE)