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.2.1
Depends: R (≥ 3.1)
Imports: assertthat (≥ 0.2.0), blob (≥ 1.2.0), cli (≥ 3.3.0), DBI (≥ 1.0.0), dplyr (≥ 1.0.9), glue (≥ 1.2.0), lifecycle (≥ 1.0.0), magrittr, methods, pillar (≥ 1.5.0), purrr (≥ 0.2.5), R6 (≥ 2.2.2), rlang (≥ 1.0.0), tibble (≥ 1.4.2), tidyselect (≥ 0.2.4), utils, vctrs (≥ 0.4.1), 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 (≥ 1.2.0)
Published: 2022-06-27
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

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.2.1.tar.gz
Windows binaries: r-devel: dbplyr_2.2.1.zip, r-release: dbplyr_2.2.1.zip, r-oldrel: dbplyr_2.2.1.zip
macOS binaries: r-release (arm64): dbplyr_2.2.1.tgz, r-oldrel (arm64): dbplyr_2.2.1.tgz, r-release (x86_64): dbplyr_2.2.1.tgz, r-oldrel (x86_64): dbplyr_2.2.1.tgz
Old sources: dbplyr archive

Reverse dependencies:

Reverse depends: BiocFileCache, grasp2db, omopr, SQLDataFrame
Reverse imports: activAnalyzer, Andromeda, apache.sedona, basedosdados, bcdata, childesr, ckanr, CompoundDb, dbglm, dcmodifydb, farr, geospark, globaltrends, implyr, lazysf, mpathsenser, msPurity, NoRCE, Organism.dplyr, palmid, pointblank, qst, RClickhouse, ReviewR, rfishbase, sergeant, shinyNotes, soundClass, sparklyr, sparklyr.flint, sqliteutils, sqlscore, synaptome.db, taxadb, taxizedb, tidyhydat, tidyverse, validatedb, vegdata, VicmapR, wordbankr
Reverse suggests: arkdb, arrow, bigrquery, bigsnpr, BiocOncoTK, cansim, censo2017, chunked, corrr, cytominer, DBI, dbplot, dittodb, dlookr, dm, dplyr, duckdb, etl, gbifdb, ipumsr, macleish, mfdb, mlr3db, modeldb, noctua, pool, radiant.data, RAthena, rdataretriever, resourcer, RPresto, srvyr, starwarsdb, stevemisc, tidypredict, tidyquery, valr

Linking:

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