Connect to a DuckDB database instance
Description
duckdb() creates or reuses a database instance.
duckdb_shutdown() shuts down a database instance.
Return an adbcdrivermanager::adbc_driver() for use with Arrow Database
Connectivity via the adbcdrivermanager package.
dbConnect() connects to a database instance.
dbDisconnect() closes a DuckDB database connection, optionally shutting down
the associated instance.
Usage
duckdb(
dbdir = DBDIR_MEMORY,
read_only = FALSE,
bigint = "numeric",
config = list()
)
duckdb_shutdown(drv)
duckdb_adbc()
## S4 method for signature 'duckdb_driver'
dbConnect(
drv,
dbdir = DBDIR_MEMORY,
...,
debug = getOption("duckdb.debug", FALSE),
read_only = FALSE,
timezone_out = "UTC",
tz_out_convert = c("with", "force"),
config = list(),
bigint = "numeric"
)
## S4 method for signature 'duckdb_connection'
dbDisconnect(conn, ..., shutdown = FALSE)
duckdb(
dbdir = DBDIR_MEMORY,
read_only = FALSE,
bigint = "numeric",
config = list()
)
duckdb_shutdown(drv)
duckdb_adbc()
dbConnect(
drv,
dbdir = DBDIR_MEMORY,
...,
debug = getOption("duckdb.debug", FALSE),
read_only = FALSE,
timezone_out = "UTC",
tz_out_convert = c("with", "force"),
config = list(),
bigint = "numeric"
)
dbDisconnect(conn, ..., shutdown = FALSE)
Arguments
dbdir |
Location for database files. Should be a path to an existing
directory in the file system. With the default, all
data is kept in RAM
|
read_only |
Set to TRUE for read-only operation
|
bigint |
How 64-bit integers should be returned, default is double/numeric. Set to integer64 for bit64 encoding.
|
config |
Named list with DuckDB configuration flags
|
drv |
Object returned by duckdb()
|
... |
Ignored
|
debug |
Print additional debug information such as queries
|
timezone_out |
The time zone returned to R, defaults to "UTC", which
is currently the only timezone supported by duckdb.
If you want to display datetime values in the local timezone,
set to Sys.timezone() or "".
|
tz_out_convert |
How to convert timestamp columns to the timezone specified
in timezone_out. There are two options: "with", and "force". If "with"
is chosen, the timestamp will be returned as it would appear in the specified time zone.
If "force" is chosen, the timestamp will have the same clock
time as the timestamp in the database, but with the new time zone.
|
conn |
A duckdb_connection object
|
shutdown |
Set to TRUE to shut down the DuckDB database instance that this connection refers to.
|
Value
duckdb() returns an object of class duckdb_driver.
dbDisconnect() and duckdb_shutdown() are called for their
side effect.
An object of class "adbc_driver"
dbConnect() returns an object of class
duckdb_connection.
Examples
library(adbcdrivermanager)
with_adbc(db <- adbc_database_init(duckdb_adbc()), {
as.data.frame(read_adbc(db, "SELECT 1 as one;"))
})
drv <- duckdb()
con <- dbConnect(drv)
dbGetQuery(con, "SELECT 'Hello, world!'")
dbDisconnect(con)
duckdb_shutdown(drv)
# Shorter:
con <- dbConnect(duckdb())
dbGetQuery(con, "SELECT 'Hello, world!'")
dbDisconnect(con, shutdown = TRUE)
library(adbcdrivermanager)
with_adbc(db <- adbc_database_init(duckdb_adbc()), {
as.data.frame(read_adbc(db, "SELECT 1 as one;"))
})
drv <- duckdb()
con <- dbConnect(drv)
dbGetQuery(con, "SELECT 'Hello, world!'")
dbDisconnect(con)
duckdb_shutdown(drv)
con <- dbConnect(duckdb())
dbGetQuery(con, "SELECT 'Hello, world!'")
dbDisconnect(con, shutdown = TRUE)
,
Mark Raasveldt [aut]