dbConnect: Adbi driver

In adbi: 'DBI' Compliant Database Access Using 'ADBC'

Adbi driver

Description

In order to open a database connection, DBI::dbConnect() dispatches on a driver object, which can be instantiated by calling adbi().

Usage

adbi(driver = NA_character_)

## S4 method for signature 'AdbiDriver'
dbConnect(drv, ..., bigint = NULL)

## S4 method for signature 'AdbiConnection'
dbDisconnect(conn, force = getOption("adbi.force_close_results", FALSE), ...)

Arguments

driver	A driver specification that can be evaluated (with no arguments) to give an adbcdrivermanager::adbc_driver(). See Details for more information.
drv	An object that inherits from DBI::DBIDriver, or an existing DBI::DBIConnection object (in order to clone an existing connection).
...	Extra arguments passed to DBI::dbConnect() are forwarded to adbcdrivermanager::adbc_database_init()
bigint	The R type that 64-bit integer types should be mapped to, default is bit64::integer64, if bit64 is installed and character otherwise
conn	A DBI::DBIConnection object, as returned by DBI::dbConnect().
force	Close open results when disconnecting

Details

To specify the type of adbc driver, adbi accepts as driver argument

• an object inheriting from adbc_driver,

• a function that can be evaluated with no arguments and returns an object inheriting from adbc_driver,

• a string of the form pkg::fun (where ⁠pkg::⁠ is optional and defaults to fun), which can be used to look up such a function.

As default, an adbcdrivermanager::adbc_driver_monkey() object is created.

Value

A connection object (S4 class AdbiCOnnection, inheriting from DBI::DBIConnection) is returned by DBI::dbConnect(), while DBI::dbDisconnect() returns TRUE invisibly.

Examples

adbi()
if (requireNamespace("adbcsqlite")) {
  adbi("adbcsqlite")
}
library(DBI)
con <- dbConnect(adbi())
dbIsValid(con)
dbDisconnect(con)
dbIsValid(con)

adbi documentation built on Sept. 9, 2025, 5:58 p.m.