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.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 <hadley at posit.co>
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 [issues need fixing before 2024-12-06]

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

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