Movatterモバイル変換

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.1
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.8),testthat (≥ 3.1.10)
Published:	2025-09-10
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 + fileLICENSE
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.html ,dbplyr.pdf
Vignettes:	dbplyr 2.0.0 backend API (source,R code) Introduction to dbplyr (source,R code) Adding a new DBI backend (source,R code) Reprexes for dbplyr (source,R code) Writing SQL with dbplyr (source,R code) Function translation (source,R code) Verb translation (source,R code)

Downloads:

Package source:	dbplyr_2.5.1.tar.gz
Windows binaries:	r-devel:dbplyr_2.5.1.zip, r-release:dbplyr_2.5.1.zip, r-oldrel:dbplyr_2.5.1.zip
macOS binaries:	r-release (arm64):dbplyr_2.5.1.tgz, r-oldrel (arm64):dbplyr_2.5.1.tgz, r-release (x86_64):dbplyr_2.5.1.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,basedosdados,bcdata,brickster,cansim,CDMConnector,childesr,ckanr,CompoundDb,connections,connector.databricks,CuratedAtlasQueryR,DatabaseConnector,dbglm,dbi.table,diseasystore,duckdbfs,ECOTOXr,etl,farr,geospark,globaltrends,healthdb,immunarch,immundata,implyr,lazysf,mdsr,motherduck,mpathsenser,msPurity,NoRCE,omopgenerics,OmopOnSpark,Organism.dplyr,osdc,overtureR,pointblank,pysparklyr,qst,ragnar,RClickhouse,redquack,ResultModelManager,ReviewR,RPresto,SCDB,sergeant,shinyNotes,simaerep,snowquery,soundClass,sparklyr,sparklyr.flint,sqliteutils,sqlscore,synaptome.db,taxadb,taxizedb,tidier,tidyhydat,tidyverse,TreatmentPatterns,vegdata,writer
Reverse suggests:	arkdb,arrow,bigrquery,bigsnpr,censo2017,censobr,chunked,CohortCharacteristics,CohortSymmetry,connectapi,connector,contoso,corrr,covidmx,cytominer,dataverifyr,DBI,dbplot,dittodb,dlookr,dm,dplyr,duckdb,duckplyr,editbl,epoxy,gbifdb,geocodebr,geogenr,GEOmetadb,gpkg,GRAB,IncidencePrevalence,iNZightPlots,iNZightTools,ipumsr,janitor,kidsides,macleish,mall,mfdb,mlr3db,modeldb,noctua,orbital,PatientProfiles,pool,r4ds.tutorials,radiant.data,RAthena,rcdf,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.