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.3.2
Depends: R (≥ 3.1)
Imports: blob (≥ 1.2.0), cli (≥ 3.4.1), DBI (≥ 1.0.0), dplyr (≥ 1.1.0), glue (≥ 1.2.0), lifecycle (≥ 1.0.3), magrittr, methods, pillar (≥ 1.5.0), purrr (≥ 1.0.1), R6 (≥ 2.2.2), rlang (≥ 1.0.6), tibble (≥ 1.4.2), tidyr (≥ 1.3.0), tidyselect (≥ 1.2.0), utils, vctrs (≥ 0.5.0), withr
Suggests: bit64, covr, knitr, Lahman, nycflights13, odbc, RMariaDB (≥ 1.0.2), rmarkdown, RPostgres (≥ 1.1.3), RPostgreSQL, RSQLite (≥ 2.2.15), testthat (≥ 3.0.2)
Published: 2023-03-21
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: 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


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

Reverse dependencies:

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


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