dbplyr: A 'dplyr' Back End for Databases

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.

Version:	2.5.1
Depends:	R (≥ 3.6)
Imports:	blob (≥ 1.2.0), cli (≥ 3.6.1), DBI (≥ 1.1.3), dplyr (≥ 1.1.2), glue (≥ 1.6.2), lifecycle (≥ 1.0.3), magrittr, methods, pillar (≥ 1.9.0), purrr (≥ 1.0.1), R6 (≥ 2.2.2), rlang (≥ 1.1.1), tibble (≥ 3.2.1), tidyr (≥ 1.3.0), tidyselect (≥ 1.2.1), utils, vctrs (≥ 0.6.3), withr (≥ 2.5.0)
Suggests:	bit64, covr, knitr, Lahman, nycflights13, odbc (≥ 1.4.2), RMariaDB (≥ 1.2.2), rmarkdown, RPostgres (≥ 1.4.5), RPostgreSQL, RSQLite (≥ 2.3.8), testthat (≥ 3.1.10)
Published:	2025-09-10
DOI:	10.32614/CRAN.package.dbplyr
Author:	Hadley Wickham [aut, cre], Maximilian Girlich [aut], Edgar Ruiz [aut], Posit Software, PBC [cph, fnd]
Maintainer:	Hadley Wickham <hadley at posit.co>
BugReports:	https://github.com/tidyverse/dbplyr/issues
License:	MIT + file LICENSE
URL:	https://dbplyr.tidyverse.org/, https://github.com/tidyverse/dbplyr
NeedsCompilation:	no
Language:	en-gb
Materials:	README, NEWS
In views:	Databases, ModelDeployment
CRAN checks:	dbplyr results

Documentation:

Reference manual:	dbplyr.html , dbplyr.pdf
Vignettes:	dbplyr 2.0.0 backend API (source, R code) Introduction to dbplyr (source, R code) Adding a new DBI backend (source, R code) Reprexes for dbplyr (source, R code) Writing SQL with dbplyr (source, R code) Function translation (source, R code) Verb translation (source, R code)

Downloads:

Package source:	dbplyr_2.5.1.tar.gz
Windows binaries:	r-devel: dbplyr_2.5.1.zip, r-release: dbplyr_2.5.1.zip, r-oldrel: dbplyr_2.5.1.zip
macOS binaries:	r-release (arm64): dbplyr_2.5.1.tgz, r-oldrel (arm64): dbplyr_2.5.1.tgz, r-release (x86_64): dbplyr_2.5.1.tgz, r-oldrel (x86_64): dbplyr_2.5.0.tgz
Old sources:	dbplyr archive

Reverse dependencies:

Reverse depends:	BiocFileCache, grasp2db
Reverse imports:	activAnalyzer, allofus, Andromeda, apache.sedona, basedosdados, bcdata, brickster, cansim, CDMConnector, childesr, ckanr, CohortConstructor, CompoundDb, connections, connector.databricks, CuratedAtlasQueryR, DatabaseConnector, dbglm, dbi.table, diseasystore, duckdbfs, ECOTOXr, etl, farr, geospark, globaltrends, healthdb, immunarch, immundata, implyr, lazysf, mdsr, mpathsenser, msPurity, NoRCE, omopgenerics, OmopOnSpark, Organism.dplyr, overtureR, pointblank, pysparklyr, qst, ragnar, RClickhouse, redquack, ResultModelManager, ReviewR, RPresto, SCDB, sergeant, shinyNotes, simaerep, snowquery, soundClass, sparklyr, sparklyr.flint, sqliteutils, sqlscore, synaptome.db, taxadb, taxizedb, tidier, tidyhydat, tidyverse, TreatmentPatterns, vegdata, writer
Reverse suggests:	arkdb, arrow, bigrquery, bigsnpr, censo2017, censobr, chunked, CohortCharacteristics, CohortSymmetry, connectapi, connector, corrr, covidmx, cytominer, dataverifyr, DBI, dbplot, dittodb, dlookr, dm, dplyr, duckdb, duckplyr, editbl, epoxy, gbifdb, geocodebr, geogenr, GEOmetadb, gpkg, GRAB, IncidencePrevalence, iNZightPlots, iNZightTools, ipumsr, janitor, kidsides, macleish, mall, mfdb, mlr3db, modeldb, noctua, orbital, PatientProfiles, pool, r4ds.tutorials, radiant.data, RAthena, rcdf, rdataretriever, resourcer, rolap, srvyr, starwarsdb, stevemisc, tidyfinance, tidypredict, tidyquery, valr, when

Linking:

Please use the canonical form https://CRAN.R-project.org/package=dbplyr to link to this page.