The hardware and bandwidth for this mirror is donated by METANET, the Webhosting and Full Service-Cloud Provider.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]metanet.ch.

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

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.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.