Skip to content

dbplyr

A 'dplyr' Back End for Databases

v2.5.2 · Feb 12, 2026 · MIT + file LICENSE
CRAN GitHub Mirror

Description

A 'dplyr' back end for databases that allows you to work with remote database tables as if they are in-memory data frames. Basic features works with any database that has a 'DBI' back end; more advanced features require 'SQL' translation to be provided by the package author.

Downloads

550.9K

Last 30 days

115th

1.7M

Last 90 days

7.5M

Last year

Trend: -2.5% (30d vs prior 30d)

CRAN Check Status

2 ERROR
12 OK
Show all 14 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-macos-arm64 OK
r-devel-windows-x86_64 OK
r-oldrel-macos-arm64 ERROR
r-oldrel-macos-x86_64 ERROR
r-oldrel-windows-x86_64 OK
r-patched-linux-x86_64 OK
r-release-linux-x86_64 OK
r-release-macos-arm64 OK
r-release-macos-x86_64 OK
r-release-windows-x86_64 OK
Check details (2 non-OK)
ERROR r-oldrel-macos-arm64

tests

Running ‘testthat.R’ [39s/20s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > library(testthat)
  > library(dbplyr)
  > 
  > test_check("dbplyr")
  Starting 2 test processes.
  > test-table-name.R: Warning message:
  > test-table-name.R: call dbDisconnect() when finished working with a connection 
  > test-verb-joins.R: Joining with `by = join_by(x)`
  Saving _problems/test-verb-pivot-longer-64.R
  Saving _problems/test-verb-pivot-longer-104.R
  Saving _problems/test-verb-pivot-longer-120.R
  Saving _problems/test-verb-pivot-longer-174.R
  Saving _problems/test-verb-pivot-longer-189.R
  [ FAIL 5 | WARN 0 | SKIP 374 | PASS 1699 ]
  
  ══ Skipped tests (374) ═════════════════════════════════════════════════════════
  • Need at least two srcs to compare (5): 'test-verb-compute.R:34:3',
    'test-verb-copy-to.R:18:3', 'test-verb-copy-to.R:27:3',
    'test-verb-set-ops.R:49:3', 'test-verb-set-ops.R:93:3'
  • No MariaDB (5): 'test-backend-mysql.R:104:3', 'test-backend-m
...[truncated]...
e", "n"), names_sep = "_")
    8. └─dbplyr:::pivot_longer.tbl_lazy(...)
    9.   └─tidyr::build_longer_spec(...)
   10.     └─tidyr:::str_separate(names, names_to, sep = names_sep, error_call = error_call)
   11.       └─tidyr:::str_split_fixed(...)
   12.         └─tidyr:::simplifyPieces(pieces, n, fill == "left")
  ── Error ('test-verb-pivot-longer.R:186:3'): .value can be at any position in `names_to` ──
  Error in `simplifyPieces(pieces, n, fill == "left")`: SET_VECTOR_ELT() can only be applied to a 'list', not a 'promise'
  Backtrace:
      ▆
   1. ├─tidyr::pivot_longer(...) at test-verb-pivot-longer.R:186:3
   2. └─dbplyr:::pivot_longer.tbl_lazy(...)
   3.   └─tidyr::build_longer_spec(...)
   4.     └─tidyr:::str_separate(names, names_to, sep = names_sep, error_call = error_call)
   5.       └─tidyr:::str_split_fixed(...)
   6.         └─tidyr:::simplifyPieces(pieces, n, fill == "left")
  
  [ FAIL 5 | WARN 0 | SKIP 374 | PASS 1699 ]
  Error:
  ! Test failures.
  Execution halted
ERROR r-oldrel-macos-x86_64

tests

Running ‘testthat.R’ [115s/101s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > library(testthat)
  > library(dbplyr)
  > 
  > test_check("dbplyr")
  Starting 2 test processes.
  > test-tidyeval-across.R: Warning message:
  > test-tidyeval-across.R: call dbDisconnect() when finished working with a connection 
  > test-verb-joins.R: Joining with `by = join_by(x)`
  Saving _problems/test-verb-pivot-longer-64.R
  Saving _problems/test-verb-pivot-longer-104.R
  Saving _problems/test-verb-pivot-longer-120.R
  Saving _problems/test-verb-pivot-longer-174.R
  Saving _problems/test-verb-pivot-longer-189.R
  [ FAIL 5 | WARN 0 | SKIP 374 | PASS 1699 ]
  
  ══ Skipped tests (374) ═════════════════════════════════════════════════════════
  • Need at least two srcs to compare (5): 'test-verb-compute.R:34:3',
    'test-verb-copy-to.R:18:3', 'test-verb-copy-to.R:27:3',
    'test-verb-set-ops.R:49:3', 'test-verb-set-ops.R:93:3'
  • No MariaDB (5): 'test-backend-mysql.R:104:3', 'te
...[truncated]...
"n"), names_sep = "_")
    8. └─dbplyr:::pivot_longer.tbl_lazy(...)
    9.   └─tidyr::build_longer_spec(...)
   10.     └─tidyr:::str_separate(names, names_to, sep = names_sep, error_call = error_call)
   11.       └─tidyr:::str_split_fixed(...)
   12.         └─tidyr:::simplifyPieces(pieces, n, fill == "left")
  ── Error ('test-verb-pivot-longer.R:186:3'): .value can be at any position in `names_to` ──
  Error in `simplifyPieces(pieces, n, fill == "left")`: SET_VECTOR_ELT() can only be applied to a 'list', not a 'environment'
  Backtrace:
      ▆
   1. ├─tidyr::pivot_longer(...) at test-verb-pivot-longer.R:186:3
   2. └─dbplyr:::pivot_longer.tbl_lazy(...)
   3.   └─tidyr::build_longer_spec(...)
   4.     └─tidyr:::str_separate(names, names_to, sep = names_sep, error_call = error_call)
   5.       └─tidyr:::str_split_fixed(...)
   6.         └─tidyr:::simplifyPieces(pieces, n, fill == "left")
  
  [ FAIL 5 | WARN 0 | SKIP 374 | PASS 1699 ]
  Error:
  ! Test failures.
  Execution halted

Check History

ERROR 12 OK · 0 NOTE · 0 WARNING · 2 ERROR · 0 FAILURE Mar 10, 2026
ERROR r-oldrel-macos-arm64

tests

Running ‘testthat.R’ [39s/20s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > library(testthat)
  > library(dbplyr)
  > 
  > test_check("dbplyr")
  Starting 2 test processes.
  > test-table-name.R: Warning message:
  > test-tabl
...[truncated]...
_to, sep = names_sep, error_call = error_call)
   5.       └─tidyr:::str_split_fixed(...)
   6.         └─tidyr:::simplifyPieces(pieces, n, fill == "left")
  
  [ FAIL 5 | WARN 0 | SKIP 374 | PASS 1699 ]
  Error:
  ! Test failures.
  Execution halted
ERROR r-oldrel-macos-x86_64

tests

Running ‘testthat.R’ [115s/90s]
Running the tests in ‘tests/testthat.R’ failed.
Complete output:
  > library(testthat)
  > library(dbplyr)
  > 
  > test_check("dbplyr")
  Starting 2 test processes.
  > test-table-name.R: Warning message:
  > test-tab
...[truncated]...
_to, sep = names_sep, error_call = error_call)
   5.       └─tidyr:::str_split_fixed(...)
   6.         └─tidyr:::simplifyPieces(pieces, n, fill == "left")
  
  [ FAIL 5 | WARN 0 | SKIP 374 | PASS 1699 ]
  Error:
  ! Test failures.
  Execution halted

Reverse Dependencies (129)

imports

Andromeda CDMConnector DatabaseConnector ECOTOXr OlinkAnalyze OmopOnSpark RClickhouse RPresto ResultModelManager ReviewR SCDB TreatmentPatterns activAnalyzer allofus apache.sedona basedosdados bcdata brickster cansim childesr ckanr connections connector.databricks dbglm dbi.table diseasystore duckdbfs duckspatial etl geospark globaltrends healthdb immunarch immundata implyr lazysf mdsr motherduck mpathsenser omopgenerics osdc overtureR pointblank pysparklyr qst ragnar redquack sergeant shinyNotes simaerep snowquery soundClass sparklyr sparklyr.flint sqliteutils sqlm sqlscore taxadb taxizedb ti tidier tidyhydat tidyverse wrds writer

suggests

CohortSymmetry DBI GRAB IncidencePrevalence PatientProfiles RAthena arkdb arrow bigrquery bigsnpr censo2017 censobr chunked connectapi connector contoso corrr cytominer datadiff dataverifyr dbplot dittodb dlookr dm dplyr duckdb duckplyr editbl epoxy fastreg gbifdb geocodebr geogenr gpkg healthbR iNZightPlots iNZightTools ipumsr janitor kidsides macleish mall mfdb mlr3db modeldb noctua orbital pool positron.tutorials querychat r4ds.tutorials radiant.data rcdf rdataretriever resourcer rolap srvyr starwarsdb stevemisc tidyfinance tidypredict tidyquery valr when

Dependency Network

Dependencies Reverse dependencies blob cli DBI dplyr (>= 1.1.2) glue lifecycle magrittr pillar purrr R6 rlang tibble tidyr tidyselect vctrs +1 more dependencies Andromeda CDMConnector DatabaseConnector ECOTOXr OlinkAnalyze OmopOnSpark RClickhouse RPresto ResultModelManager ReviewR SCDB TreatmentPatterns activAnalyzer allofus apache.sedona +114 more reverse deps dbplyr

Version History

new 2.5.2 Mar 10, 2026
updated 2.5.2 ← 2.5.1 diff Feb 12, 2026
updated 2.5.1 ← 2.5.0 diff Sep 9, 2025
updated 2.5.0 ← 2.4.0 diff Mar 18, 2024
updated 2.4.0 ← 2.3.4 diff Oct 25, 2023
updated 2.3.4 ← 2.3.3 diff Sep 26, 2023
updated 2.3.3 ← 2.3.2 diff Jul 6, 2023
updated 2.3.2 ← 2.3.1 diff Mar 20, 2023
updated 2.3.1 ← 2.3.0 diff Feb 23, 2023
updated 2.3.0 ← 2.2.1 diff Jan 15, 2023
updated 2.2.1 ← 2.2.0 diff Jun 26, 2022
updated 2.2.0 ← 2.1.1 diff Jun 4, 2022
updated 2.1.1 ← 2.1.0 diff Apr 5, 2021
updated 2.1.0 ← 2.0.0 diff Feb 2, 2021
updated 2.0.0 ← 1.4.4 diff Nov 2, 2020
updated 1.4.4 ← 1.4.3 diff May 26, 2020
updated 1.4.3 ← 1.4.2 diff Apr 18, 2020
updated 1.4.2 ← 1.4.1 diff Jun 16, 2019
updated 1.4.1 ← 1.4.0 diff Jun 5, 2019
updated 1.4.0 ← 1.3.0 diff Apr 23, 2019