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.0
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.1), testthat (≥ 3.1.10)
Published: 2024-03-19
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.pdf
Vignettes: dbplyr 2.0.0 backend API
Introduction to dbplyr
Adding a new DBI backend
Reprexes for dbplyr
Writing SQL with dbplyr
Function translation
Verb translation

Downloads:

Package source: dbplyr_2.5.0.tar.gz
Windows binaries: r-devel: dbplyr_2.5.0.zip, r-release: dbplyr_2.5.0.zip, r-oldrel: dbplyr_2.5.0.zip
macOS binaries: r-release (arm64): dbplyr_2.5.0.tgz, r-oldrel (arm64): dbplyr_2.5.0.tgz, r-release (x86_64): dbplyr_2.5.0.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, arcgisutils, basedosdados, bcdata, CDMConnector, childesr, ckanr, CohortConstructor, CohortSurvival, CompoundDb, connections, CuratedAtlasQueryR, DatabaseConnector, dbglm, dbi.table, diseasystore, duckdbfs, ECOTOXr, etl, farr, geospark, globaltrends, healthdb, implyr, IncidencePrevalence, lazysf, mdsr, mpathsenser, msPurity, NoRCE, omopgenerics, Organism.dplyr, overtureR, pointblank, pysparklyr, qst, RClickhouse, ResultModelManager, ReviewR, RPresto, SCDB, sergeant, shinyNotes, simaerep, soundClass, sparklyr, sparklyr.flint, sqliteutils, sqlscore, synaptome.db, taxadb, tidier, tidyhydat, tidyverse, vegdata, VicmapR
Reverse suggests: arcgislayers, arkdb, arrow, bigrquery, bigsnpr, cansim, censo2017, censobr, chunked, CohortCharacteristics, CohortSymmetry, connectapi, corrr, covidmx, cytominer, dataverifyr, DBI, dbplot, dittodb, dlookr, dm, dplyr, duckdb, duckplyr, editbl, epoxy, gbifdb, geogenr, gpkg, iNZightPlots, iNZightTools, ipumsr, janitor, kidsides, macleish, mall, mfdb, mlr3db, modeldb, noctua, orbital, PatientProfiles, pool, r4ds.tutorials, radiant.data, RAthena, 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.