dbplyr: A 'dplyr' Back End for Databases (original) (raw)

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
BugReports: https://github.com/tidyverse/dbplyr/issues
License: MIT + file
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:

Downloads:

Reverse dependencies:

Reverse depends: BiocFileCache, grasp2db
Reverse imports: activAnalyzer, allofus, Andromeda, apache.sedona, basedosdados, bcdata, brickster, cansim, CDMConnector, childesr, ckanr, 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 formhttps://CRAN.R-project.org/package=dbplyrto link to this page.