Other packages > Find by keyword >

dbplyr  

A 'dplyr' Back End for Databases
View on CRAN: Click here


Download and install dbplyr package within the R console
Install from CRAN:
install.packages("dbplyr")

Install from Github:
library("remotes")
install_github("cran/dbplyr")

Install by package version:
library("remotes")
install_version("dbplyr", "2.6.0")



Attach the package and use:
library("dbplyr")
Maintained by
Hadley Wickham
[Scholar Profile | Author Map]
All associated links for this package
First Published: 2017-06-09
Latest Update: 2025-09-03
Description:
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.
How to cite:
Hadley Wickham (2017). dbplyr: A 'dplyr' Back End for Databases. R package version 2.6.0, https://cran.r-project.org/web/packages/dbplyr. Accessed 07 Oct. 2026.
Previous versions and publish date:
(2026-07-09 07:30), 1.0.0 (2017-06-09 13:08), 1.1.0 (2017-06-27 08:55), 1.2.0 (2018-01-03 14:35), 1.2.1 (2018-02-19 20:40), 1.2.2 (2018-07-25 17:00), 1.3.0 (2019-01-09 14:20), 1.4.0 (2019-04-24 00:40), 1.4.1 (2019-06-06 00:50), 1.4.2 (2019-06-17 22:00), 1.4.3 (2020-04-19 11:40), 1.4.4 (2020-05-27 07:30), 2.0.0 (2020-11-03 07:40), 2.1.0 (2021-02-03 22:20), 2.1.1 (2021-04-06 14:50), 2.2.0 (2022-06-05 18:10), 2.2.1 (2022-06-27 17:20), 2.3.0 (2023-01-16 19:40), 2.3.1 (2023-02-24 19:20), 2.3.2 (2023-03-21 21:30), 2.3.3 (2023-07-07 17:20), 2.3.4 (2023-09-27 00:40), 2.4.0 (2023-10-26 09:40), 2.5.0 (2024-03-19 18:00), 2.5.1 (2025-09-10 09:51), 2.5.2 (2026-02-13 08:01)
Other packages that cited dbplyr R package
View dbplyr citation profile
Other R packages that dbplyr depends, imports, suggests or enhances
Complete documentation for dbplyr
Functions, R codes and Examples using the dbplyr R package
Some associated functions: arrange.tbl_lazy . backend-access . backend-hana . backend-hive . backend-impala . backend-mssql . backend-mysql . backend-odbc . backend-oracle . backend-postgres . backend-redshift . backend-snowflake . backend-spark-sql . backend-sqlite . backend-teradata . build_sql . collapse.tbl_sql . complete.tbl_lazy . copy_inline . copy_to.src_sql . count.tbl_lazy . db-io . db-misc . db-quote . db-sql . dbplyr-package . dbplyr-slice . dbplyr_uncount . distinct.tbl_lazy . do.tbl_sql . escape . expand.tbl_lazy . fill.tbl_lazy . filter.tbl_lazy . get_returned_rows . group_by.tbl_lazy . head.tbl_lazy . ident . ident_q . in_schema . intersect.tbl_lazy . join.tbl_sql . lahman . lazy_ops . memdb_frame . mutate.tbl_lazy . named_commas . nycflights13 . partial_eval . pivot_longer.tbl_lazy . pivot_wider.tbl_lazy . pull.tbl_sql . reexports . remote_name . replace_na.tbl_lazy . rows-db . select.tbl_lazy . simulate_dbi . sql . sql_build . sql_expr . sql_options . sql_query_insert . sql_quote . sql_variant . src_dbi . src_sql . summarise.tbl_lazy . tbl.src_dbi . tbl_lazy . tbl_sql . testing . translate_sql . win_over . window_order . 
Some associated R codes: backend-.R . backend-access.R . backend-hana.R . backend-hive.R . backend-impala.R . backend-mssql.R . backend-mysql.R . backend-odbc.R . backend-oracle.R . backend-postgres-old.R . backend-postgres.R . backend-redshift.R . backend-snowflake.R . backend-spark-sql.R . backend-sqlite.R . backend-teradata.R . build-sql.R . data-cache.R . data-lahman.R . data-nycflights13.R . db-escape.R . db-io.R . db-sql.R . db.R . dbplyr.R . escape.R . explain.R . ident.R . import-standalone-obj-type.R . import-standalone-types-check.R . join-by-compat.R . join-cols-compat.R . lazy-join-query.R . lazy-ops.R . lazy-query.R . lazy-select-query.R . lazy-set-op-query.R . memdb.R . optimise-utils.R . pillar.R . progress.R . query-join.R . query-select.R . query-semi-join.R . query-set-op.R . query.R . reexport.R . remote.R . rows.R . schema.R . simulate.R . sql-build.R . sql-clause.R . sql-expr.R . sql.R . src-sql.R . src_dbi.R . table-ident.R . tbl-lazy.R . tbl-sql.R . test-frame.R . testthat.R . tidyeval-across.R . tidyeval.R . translate-sql-conditional.R . translate-sql-cut.R . translate-sql-helpers.R . translate-sql-paste.R . translate-sql-quantile.R . translate-sql-string.R . translate-sql-window.R . translate-sql.R . utils-check.R . utils-format.R . utils.R . verb-arrange.R . verb-compute.R . verb-copy-to.R . verb-count.R . verb-distinct.R . verb-do-query.R . verb-do.R . verb-expand.R . verb-fill.R . verb-filter.R . verb-group_by.R . verb-head.R . verb-joins.R . verb-mutate.R . verb-pivot-longer.R . verb-pivot-wider.R . verb-pull.R . verb-select.R . verb-set-ops.R . verb-slice.R . verb-summarise.R . verb-uncount.R . verb-window.R . zzz.R .  Full dbplyr package functions and examples
Downloads during the last 30 days

Today's Hot Picks in Authors and Packages

PairedData  
Paired Data Analysis
Many datasets and a set of graphics (based on ggplot2), statistics, effect sizes and hypothesis test ...
Download / Learn more Package Citations See dependency  
blandr  
Bland-Altman Method Comparison
Carries out Bland Altman analyses (also known as a Tukey mean-difference plot) as described by JM B ...
Download / Learn more Package Citations See dependency  
ggTimeSeries  
Time Series Visualisations Using the Grammar of Graphics
Provides additional display mediums for time series visualisations. ...
Download / Learn more Package Citations See dependency  
nextGenShinyApps  
Craft Exceptional 'R Shiny' Applications and Dashboards with Novel Responsive Tools
Nove responsive tools for designing and developing 'Shiny' dashboards and applications. The scripts ...
Download / Learn more Package Citations See dependency  
splm  
Econometric Models for Spatial Panel Data
ML and GM estimation and diagnostic testing of econometric models for spatial panel data. ...
Download / Learn more Package Citations See dependency  
plaqr  
Partially Linear Additive Quantile Regression
Estimation, prediction, thresholding, transformation, and plotting for partially linear additive qua ...
Download / Learn more Package Citations See dependency  

28,905

R Packages

247,686

Dependencies

76,495

Author Associations

28,906

Publication Badges

© Copyright since 2022. All right reserved, rpkg.net.  Based in Cambridge, Massachusetts, USA