Package: adbcdrivermanager 0.18.0

Dewey Dunnington

adbcdrivermanager: 'Arrow' Database Connectivity ('ADBC') Driver Manager

Provides a developer-facing interface to 'Arrow' Database Connectivity ('ADBC') for the purposes of driver development, driver testing, and building high-level database interfaces for users. 'ADBC' <https://arrow.apache.org/adbc/> is an API standard for database access libraries that uses 'Arrow' for result sets and query parameters.

Authors:Dewey Dunnington [aut, cre], Apache Arrow [aut, cph], Apache Software Foundation [cph]

adbcdrivermanager_0.18.0.tar.gz
adbcdrivermanager_0.18.0.zip(r-4.6)adbcdrivermanager_0.18.0.zip(r-4.5)adbcdrivermanager_0.18.0.zip(r-4.4)
adbcdrivermanager_0.18.0.tgz(r-4.5-x86_64)adbcdrivermanager_0.18.0.tgz(r-4.5-arm64)adbcdrivermanager_0.18.0.tgz(r-4.4-x86_64)adbcdrivermanager_0.18.0.tgz(r-4.4-arm64)
adbcdrivermanager_0.18.0.tar.gz(r-4.6-arm64)adbcdrivermanager_0.18.0.tar.gz(r-4.6-x86_64)adbcdrivermanager_0.18.0.tar.gz(r-4.5-arm64)adbcdrivermanager_0.18.0.tar.gz(r-4.5-x86_64)
adbcdrivermanager_0.18.0.tgz(r-4.5-emscripten)adbcdrivermanager_0.18.0.tgz(r-4.4-emscripten)
adbcdrivermanager.pdf |adbcdrivermanager.html
adbcdrivermanager/json (API)

# Install 'adbcdrivermanager' in R:
install.packages('adbcdrivermanager', repos = c('https://community.r-multiverse.org', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/apache/arrow-adbc/issues

Pkgdown site:https://arrow.apache.org

Uses libs:
  • c++– GNU Standard C++ Library v3

On CRAN:adbcdrivermanager-0.18.0(2025-05-27)

Conda:

arrowdatabasecpp

11.40 score 453 stars 6 packages 74 scripts 2.5k downloads 59 exports 1 dependencies

Last updated 1 months ago from:b093c15341 (on apache-arrow-adbc-18). Checks:14 OK. Indexed: no.

TargetResultTotal time
linux-devel-arm64OK110
linux-devel-x86_64OK105
source / vignettesOK142
linux-release-arm64OK114
linux-release-x86_64OK108
macos-release-arm64OK92
macos-release-x86_64OK134
macos-oldrel-arm64OK97
macos-oldrel-x86_64OK133
windows-develOK97
windows-releaseOK93
windows-oldrelOK151
wasm-releaseOK85
wasm-oldrelOK84

Exports:adbc_connection_canceladbc_connection_commitadbc_connection_get_infoadbc_connection_get_objectsadbc_connection_get_optionadbc_connection_get_option_bytesadbc_connection_get_option_doubleadbc_connection_get_option_intadbc_connection_get_statistic_namesadbc_connection_get_statisticsadbc_connection_get_table_schemaadbc_connection_get_table_typesadbc_connection_initadbc_connection_init_defaultadbc_connection_joinadbc_connection_quote_identifieradbc_connection_quote_stringadbc_connection_read_partitionadbc_connection_releaseadbc_connection_rollbackadbc_connection_set_optionsadbc_database_get_optionadbc_database_get_option_bytesadbc_database_get_option_doubleadbc_database_get_option_intadbc_database_initadbc_database_init_defaultadbc_database_releaseadbc_database_set_optionsadbc_driveradbc_driver_logadbc_driver_monkeyadbc_driver_voidadbc_error_from_array_streamadbc_statement_bindadbc_statement_bind_streamadbc_statement_canceladbc_statement_execute_queryadbc_statement_execute_schemaadbc_statement_get_optionadbc_statement_get_option_bytesadbc_statement_get_option_doubleadbc_statement_get_option_intadbc_statement_get_parameter_schemaadbc_statement_initadbc_statement_init_defaultadbc_statement_joinadbc_statement_prepareadbc_statement_releaseadbc_statement_set_optionsadbc_statement_set_sql_queryadbc_statement_set_substrait_planadbc_xptr_is_validadbc_xptr_moveexecute_adbclocal_adbcread_adbcwith_adbcwrite_adbc

Dependencies:nanoarrow

Citation

To cite package ‘adbcdrivermanager’ in publications use:

Dunnington D, Apache Arrow (2025). adbcdrivermanager: 'Arrow' Database Connectivity ('ADBC') Driver Manager. R package version 0.18.0, https://github.com/apache/arrow-adbc.

Corresponding BibTeX entry:

  @Manual{,
    title = {adbcdrivermanager: 'Arrow' Database Connectivity ('ADBC')
      Driver Manager},
    author = {Dewey Dunnington and {Apache Arrow}},
    year = {2025},
    note = {R package version 0.18.0},
    url = {https://github.com/apache/arrow-adbc},
  }

Readme and manuals

adbcdrivermanager

The goal of adbcdrivermanager is to provide a low-level developer-facing interface to Arrow Database Connectivity (ADBC) for the purposes of driver development, testing, and support for user-facing packages that rely on ADBC drivers.

Installation

You can install the released version of adbcdrivermanager from CRAN with:

install.packages("adbcdrivermanager")

You can install the development version of adbcdrivermanager from GitHub with:

# install.packages("pak")
pak::pak("apache/arrow-adbc/r/adbcdrivermanager")

ADBC drivers for R use a relatively new feature of pkgbuild to enable installation from GitHub via pak. Depending on when you installed pak, you may need to update its internal version of pkgbuild.

install.packages("pkgbuild", pak:::private_lib_dir())
pak::cache_clean()

Example

This is a basic example which shows you how to solve a common problem:

library(adbcdrivermanager)

# Get a reference to a database using a driver. The adbcdrivermanager package
# contains a few drivers useful for illustration and testing.
db <- adbc_database_init(adbcsqlite::adbcsqlite())

# Open a new connection to a database
con <- adbc_connection_init(db)

# Write a table
nycflights13::flights |> write_adbc(con, "flights")

# Issue a query
con |>
  read_adbc("SELECT * from flights") |>
  tibble::as_tibble()
#> # A tibble: 336,776 × 19
#>     year month   day dep_time sched_dep_time dep_delay arr_time sched_arr_time
#>    <dbl> <dbl> <dbl>    <dbl>          <dbl>     <dbl>    <dbl>          <dbl>
#>  1  2013     1     1      517            515         2      830            819
#>  2  2013     1     1      533            529         4      850            830
#>  3  2013     1     1      542            540         2      923            850
#>  4  2013     1     1      544            545        -1     1004           1022
#>  5  2013     1     1      554            600        -6      812            837
#>  6  2013     1     1      554            558        -4      740            728
#>  7  2013     1     1      555            600        -5      913            854
#>  8  2013     1     1      557            600        -3      709            723
#>  9  2013     1     1      557            600        -3      838            846
#> 10  2013     1     1      558            600        -2      753            745
#> # ℹ 336,766 more rows
#> # ℹ 11 more variables: arr_delay <dbl>, carrier <chr>, flight <dbl>,
#> #   tailnum <chr>, origin <chr>, dest <chr>, air_time <dbl>, distance <dbl>,
#> #   hour <dbl>, minute <dbl>, time_hour <chr>

# Clean up!
adbc_connection_release(con)
adbc_database_release(db)

One can also interact with the driver manager at a lower level using adbc_connection_*() and adbc_statement_*() functions (see reference documentation for details).

Help Manual

Help pageTopics
Connection methodsadbc_connection_cancel adbc_connection_commit adbc_connection_get_info adbc_connection_get_objects adbc_connection_get_statistics adbc_connection_get_statistic_names adbc_connection_get_table_schema adbc_connection_get_table_types adbc_connection_quote_identifier adbc_connection_quote_string adbc_connection_read_partition adbc_connection_rollback
Connectionsadbc_connection_get_option adbc_connection_get_option_bytes adbc_connection_get_option_double adbc_connection_get_option_int adbc_connection_init adbc_connection_init_default adbc_connection_release adbc_connection_set_options
Join the lifecycle of a unique parent to its childadbc_connection_join adbc_statement_join
Databasesadbc_database_get_option adbc_database_get_option_bytes adbc_database_get_option_double adbc_database_get_option_int adbc_database_init adbc_database_init_default adbc_database_release adbc_database_set_options
Log calls to another driveradbc_driver_log
Monkey see, monkey do!adbc_driver_monkey
Create ADBC driversadbc_driver adbc_driver_void
Get extended error information from an array streamadbc_error_from_array_stream
Statementsadbc_statement_get_option adbc_statement_get_option_bytes adbc_statement_get_option_double adbc_statement_get_option_int adbc_statement_init adbc_statement_init_default adbc_statement_release adbc_statement_set_options
Statement methodsadbc_statement_bind adbc_statement_bind_stream adbc_statement_cancel adbc_statement_execute_query adbc_statement_execute_schema adbc_statement_get_parameter_schema adbc_statement_prepare adbc_statement_set_sql_query adbc_statement_set_substrait_plan
Low-level pointer detailsadbc_xptr_is_valid adbc_xptr_move
Read, write, and execute on ADBC connectionsexecute_adbc read_adbc write_adbc
Cleanup helperslocal_adbc with_adbc