Package: adbcdrivermanager 0.18.0
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:
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
On CRAN:adbcdrivermanager-0.18.0(2025-05-27)
Last updated 1 months ago from:b093c15341 (on apache-arrow-adbc-18). Checks:14 OK. Indexed: no.
Target | Result | Total time |
---|---|---|
linux-devel-arm64 | OK | 110 |
linux-devel-x86_64 | OK | 105 |
source / vignettes | OK | 142 |
linux-release-arm64 | OK | 114 |
linux-release-x86_64 | OK | 108 |
macos-release-arm64 | OK | 92 |
macos-release-x86_64 | OK | 134 |
macos-oldrel-arm64 | OK | 97 |
macos-oldrel-x86_64 | OK | 133 |
windows-devel | OK | 97 |
windows-release | OK | 93 |
windows-oldrel | OK | 151 |
wasm-release | OK | 85 |
wasm-oldrel | OK | 84 |
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 page | Topics |
---|---|
Connection methods | adbc_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 |
Connections | adbc_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 child | adbc_connection_join adbc_statement_join |
Databases | adbc_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 driver | adbc_driver_log |
Monkey see, monkey do! | adbc_driver_monkey |
Create ADBC drivers | adbc_driver adbc_driver_void |
Get extended error information from an array stream | adbc_error_from_array_stream |
Statements | adbc_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 methods | adbc_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 details | adbc_xptr_is_valid adbc_xptr_move |
Read, write, and execute on ADBC connections | execute_adbc read_adbc write_adbc |
Cleanup helpers | local_adbc with_adbc |