CRAN/E | dbplyr

dbplyr

A 'dplyr' Back End for Databases

Installation

About

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.

dbplyr.tidyverse.org/
github.com/tidyverse/dbplyr
Bug report File report

Key Metrics

Version 2.5.0
R ≥ 3.6
Published 2024-03-19 9 days ago
Needs compilation? no
License MIT
License File
CRAN checks dbplyr results
Language en-gb

Downloads

Yesterday 24.907 0%
Last 7 days 109.689 -23%
Last 30 days 498.654 -13%
Last 90 days 1.545.538 -13%
Last 365 days 6.798.141 -8%

Maintainer

Maintainer

Hadley Wickham

hadley@posit.co

Authors

Hadley Wickham

aut / cre

Maximilian Girlich

aut

Edgar Ruiz

aut

Posit Software
PBC

cph / fnd

Material

README
NEWS
Reference manual
Package source

In Views

Databases
ModelDeployment

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

macOS

r-release

arm64

r-oldrel

arm64

r-release

x86_64

Windows

r-devel

x86_64

r-release

x86_64

r-oldrel

x86_64

Old Sources

dbplyr archive

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

Reverse Depends

BiocFileCache
grasp2db
SQLDataFrame

Reverse Imports

activAnalyzer
allofus
Andromeda
apache.sedona
arcgisutils
basedosdados
bcdata
CDMConnector
childesr
ckanr
CohortSurvival
CompoundDb
connections
CuratedAtlasQueryR
DatabaseConnector
dbglm
diseasystore
DrugUtilisation
duckdbfs
ECOTOXr
etl
farr
geospark
globaltrends
implyr
IncidencePrevalence
lazysf
mdsr
mpathsenser
msPurity
NoRCE
omopgenerics
Organism.dplyr
pointblank
pysparklyr
qst
RClickhouse
ReviewR
rfishbase
RPresto
SCDB
sergeant
shinyNotes
soundClass
sparklyr
sparklyr.flint
sqliteutils
sqlscore
synaptome.db
taxadb
Load all 57 items
(warning: might lead to performance issues and take some time)

Reverse Suggests

arcgislayers
arkdb
arrow
bigrquery
bigsnpr
BiocOncoTK
cansim
censo2017
chunked
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
PatientProfiles
pool
r4ds.tutorials
radiant.data
RAthena
rdataretriever
resourcer
rolap
srvyr
starwarsdb
stevemisc
tidyfinance
tidypredict
Load all 53 items
(warning: might lead to performance issues and take some time)