Skip to content

adbi

'DBI' Compliant Database Access Using 'ADBC'

v0.1.2 · Sep 3, 2025 · LGPL (>= 2.1)

Description

In order to make Arrow Database Connectivity ('ADBC' <https://arrow.apache.org/adbc/>) accessible from R, an interface compliant with the 'DBI' package is provided, using driver back-ends that are implemented in the 'adbcdrivermanager' framework. This enables interacting with database systems using the Arrow data format, thereby offering an efficient alternative to 'ODBC' for analytical applications.

Downloads

1.9K

Last 30 days

2828th

2.5K

Last 90 days

5.3K

Last year

Trend: +602.6% (30d vs prior 30d)

CRAN Check Status

2 ERROR
11 OK
Show all 13 flavors
Flavor Status
r-devel-linux-x86_64-debian-clang OK
r-devel-linux-x86_64-debian-gcc OK
r-devel-linux-x86_64-fedora-clang OK
r-devel-linux-x86_64-fedora-gcc OK
r-devel-windows-x86_64 OK
r-oldrel-macos-arm64 OK
r-oldrel-macos-x86_64 OK
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 ERROR
r-release-macos-x86_64 ERROR
r-release-windows-x86_64 OK
Check details (3 non-OK)
ERROR r-release-macos-arm64

examples

Running examples in ‘adbi-Ex.R’ failed
The error most likely occurred in:

> ### Name: adbi
> ### Title: Adbi driver
> ### Aliases: adbi dbConnect_AdbiDriver dbConnect,AdbiDriver-method
> ###   dbDisconnect_AdbiConnection dbDisconnect,AdbiConnection-method
> 
> ### ** Examples
> 
> adbi()
<AdbiDriver>
  Type: <adbc_driver_monkey>
> if (requireNamespace("adbcsqlite")) {
+   adbi("adbcsqlite")
+ }
Loading required namespace: adbcsqlite
Error in get(fun, envir = asNamespace(pkg), mode = "function", inherits = FALSE) : 
  cannot open file '/Volumes/Builds/packages/sonoma-arm64/Rlib/4.6/adbcsqlite/R/adbcsqlite.rdb': No such file or directory
Calls: adbi -> get
Execution halted
ERROR r-release-macos-arm64

tests

Running ‘testthat.R’ [0s/0s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional test configuration?
  > # Learn more about the roles of various files in:
  > # * https://r-pkgs.org/testing-design.html#sec-tests-files-overview
  > # * https://testthat.r-lib.org/articles/special-files.html
  > 
  > library(testthat)
  > library(adbi)
  > 
  > test_check("adbi")
  Error in `source_dir()`:
  ! Failed to evaluate './helper-DBItest.R'.
  Caused by error in `loadNamespace()`:
  ! there is no package called 'adbcsqlite'
  Backtrace:
       ▆
    1. ├─testthat::test_check("adbi")
    2. │ └─testthat::test_dir(...)
    3. │   └─testthat:::test_files(...)
    4. │     └─testthat:::test_files_serial(...)
    5. │       └─testthat:::test_files_setup_state(...)
    6. │         └─testthat::source_test_helpers(".", env)
    7. │       
...[truncated]...
ake_context(...) at ./helper-DBItest.R:1:1
   15. │                       └─adbi::adbi("adbcsqlite") at DBItest/R/context.R:48:3
   16. │                         ├─base::get(fun, envir = asNamespace(pkg), mode = "function", inherits = FALSE)
   17. │                         └─base::asNamespace(pkg)
   18. │                           └─base::getNamespace(ns)
   19. │                             ├─.Internal(getRegisteredNamespace(name)) %||% ...
   20. │                             └─base::loadNamespace(name)
   21. │                               ├─base::withRestarts(stop(cond), retry_loadNamespace = function() NULL)
   22. │                               │ └─base (local) withOneRestart(expr, restarts[[1L]])
   23. │                               │   └─base (local) doWithOneRestart(return(expr), restart)
   24. │                               └─base::stop(cond)
   25. └─testthat (local) `<fn>`(`<pckgNtFE>`)
   26.   └─cli::cli_abort(...)
   27.     └─rlang::abort(...)
  Execution halted
ERROR r-release-macos-x86_64

tests

Running ‘testthat.R’ [1s/2s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional test configuration?
  > # Learn more about the roles of various files in:
  > # * https://r-pkgs.org/testing-design.html#sec-tests-files-overview
  > # * https://testthat.r-lib.org/articles/special-files.html
  > 
  > library(testthat)
  > library(adbi)
  > 
  > test_check("adbi")
  Error in `source_dir()`:
  ! Failed to evaluate './helper-DBItest.R'.
  Caused by error in `loadNamespace()`:
  ! there is no package called 'adbcsqlite'
  Backtrace:
       ▆
    1. ├─testthat::test_check("adbi")
    2. │ └─testthat::test_dir(...)
    3. │   └─testthat:::test_files(...)
    4. │     └─testthat:::test_files_serial(...)
    5. │       └─testthat:::test_files_setup_state(...)
    6. │         └─testthat::source_test_helpers(".", env)
    7. │       
...[truncated]...
ake_context(...) at ./helper-DBItest.R:1:1
   15. │                       └─adbi::adbi("adbcsqlite") at DBItest/R/context.R:48:3
   16. │                         ├─base::get(fun, envir = asNamespace(pkg), mode = "function", inherits = FALSE)
   17. │                         └─base::asNamespace(pkg)
   18. │                           └─base::getNamespace(ns)
   19. │                             ├─.Internal(getRegisteredNamespace(name)) %||% ...
   20. │                             └─base::loadNamespace(name)
   21. │                               ├─base::withRestarts(stop(cond), retry_loadNamespace = function() NULL)
   22. │                               │ └─base (local) withOneRestart(expr, restarts[[1L]])
   23. │                               │   └─base (local) doWithOneRestart(return(expr), restart)
   24. │                               └─base::stop(cond)
   25. └─testthat (local) `<fn>`(`<pckgNtFE>`)
   26.   └─cli::cli_abort(...)
   27.     └─rlang::abort(...)
  Execution halted

Changelog

Full NEWS →

v0.1.2

# adbi 0.1.2 (2024-09-03)

• Docs only update

Check History

ERROR 11 OK · 0 NOTE · 0 WARNING · 1 ERROR · 0 FAILURE Apr 25, 2026
ERROR r-release-macos-x86_64

tests

Running ‘testthat.R’ [1s/2s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > # This file is part of the standard setup for testthat.
  > # It is recommended that you do not modify it.
  > #
  > # Where should you do additional te
...[truncated]...
      │   └─base (local) doWithOneRestart(return(expr), restart)
   24. │                               └─base::stop(cond)
   25. └─testthat (local) `<fn>`(`<pckgNtFE>`)
   26.   └─cli::cli_abort(...)
   27.     └─rlang::abort(...)
  Execution halted
OK 14 OK · 0 NOTE · 0 WARNING · 0 ERROR · 0 FAILURE Mar 10, 2026

Reverse Dependencies (2)

suggests

Dependency Network

Dependencies Reverse dependencies DBI adbcdrivermanager nanoarrow db2pq dbplyr adbi

Version History

5 tracked
new 0.1.2 Mar 10, 2026
updated 0.1.2 ← 0.1.1 diff Sep 2, 2025
updated 0.1.1 ← 0.1.0 diff Jan 24, 2024
updated 0.1.0 ← 0.0.2 diff Dec 20, 2023
new 0.0.2 Dec 10, 2023