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.1.1
Depends: R (≥ 3.1)
Imports: assertthat (≥ 0.2.0), blob (≥ 1.2.0), DBI (≥ 1.0.0), dplyr (≥ 1.0.4), ellipsis, glue (≥ 1.2.0), lifecycle (≥ 1.0.0), magrittr, methods, purrr (≥ 0.2.5), R6 (≥ 2.2.2), rlang (≥ 0.2.0), tibble (≥ 1.4.2), tidyselect (≥ 0.2.4), utils, vctrs, withr
Suggests: bit64, covr, knitr, Lahman, nycflights13, odbc, RMariaDB (≥ 1.0.2), rmarkdown, RPostgres (≥ 1.1.3), RPostgreSQL, RSQLite (≥ 2.1.0), testthat (≥ 3.0.2), tidyr
Published: 2021-04-06
Author: Hadley Wickham [aut, cre], Maximilian Girlich [aut], Edgar Ruiz [aut], RStudio [cph, fnd]
Maintainer: Hadley Wickham <hadley at rstudio.com>
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


Reference manual: dbplyr.pdf
Vignettes: dplyr 2.0.0 backend API
Introduction to dbplyr
Adding a new DBI backend
Reprexes for dbplyr
Writing SQL with dbplyr
Function translation
Verb translation
Package source: dbplyr_2.1.1.tar.gz
Windows binaries: r-devel: dbplyr_2.1.1.zip, r-release: dbplyr_2.1.1.zip, r-oldrel: dbplyr_2.1.1.zip
macOS binaries: r-release (arm64): dbplyr_2.1.1.tgz, r-release (x86_64): dbplyr_2.1.1.tgz, r-oldrel: dbplyr_2.1.1.tgz
Old sources: dbplyr archive

Reverse dependencies:

Reverse depends: BiocFileCache, dplyr.teradata, grasp2db, omopr, SQLDataFrame
Reverse imports: Andromeda, bcdata, ckanr, connections, dbglm, geospark, implyr, lazysf, mdsr, msPurity, NoRCE, Organism.dplyr, pointblank, qst, RClickhouse, ReviewR, rfishbase, sergeant, shinyNotes, sparklyr, sparklyr.flint, sqlscore, taxadb, taxizedb, tidyhydat, tidyverse, validatedb, VicmapR, wordbankr
Reverse suggests: arkdb, bigrquery, bigsnpr, BiocOncoTK, cansim, censo2017, chunked, corrr, cytominer, DBI, dbplot, dittodb, dlookr, dm, dplyr, duckdb, etl, healthcareai, ipumsr, macleish, mfdb, mlr3db, modeldb, noctua, pool, RAthena, resourcer, RPresto, srvyr, starwarsdb, stevemisc, tidypredict, tidyquery, valr


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