dbplyr: A 'dplyr' Back End for Databases (original) (raw)

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
BugReports: https://github.com/tidyverse/dbplyr/issues
License: MIT + file
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:

Downloads:

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, diseasystore, DrugUtilisation, 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, BiocOncoTK, cansim, censo2017, censobr, chunked, CohortCharacteristics, CohortSymmetry, connectapi, corrr, covidmx, cytominer, dataverifyr, DBI, dbplot, dittodb, dlookr, dm, dplyr, duckdb, duckplyr, editbl, epoxy, gbifdb, geogenr, GEOmetadb, gpkg, iNZightPlots, iNZightTools, ipumsr, janitor, kidsides, macleish, 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 formhttps://CRAN.R-project.org/package=dbplyrto link to this page.