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 |
| 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.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 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 |
Please use the canonical form https://CRAN.R-project.org/package=dbplyr to link to this page.