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.5.0")



Attach the package and use:
library("dbplyr")
Maintained by
Hadley Wickham
[Scholar Profile | Author Map]
First Published: 2017-06-09
Latest Update: 2023-07-07
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.5.0, https://cran.r-project.org/web/packages/dbplyr. Accessed 21 Apr. 2025.
Previous versions and publish date:
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)
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
03/2203/2303/2403/2503/2603/2703/2803/2903/3003/3104/0104/0204/0304/0404/0504/0604/0704/0804/0904/1004/1104/1204/1304/1404/1504/1604/1704/1804/1904/20Downloads for dbplyr12000140001600018000200002200024000260002800030000TrendBars

Today's Hot Picks in Authors and Packages

bigsparser  
Sparse Matrix Format with Data on Disk
Provide a sparse matrix format with data stored on disk, to be used in both R and C++. This is inte ...
Download / Learn more Package Citations See dependency  
discretecdAlgorithm  
Coordinate-Descent Algorithm for Learning Sparse Discrete Bayesian Networks
Structure learning of Bayesian network using coordinate-descent algorithm. This algorithm is design ...
Download / Learn more Package Citations See dependency  
bssn  
Birnbaum-Saunders Model
It provides the density, distribution function, quantile function, random number generator, reliabil ...
Download / Learn more Package Citations See dependency  
r2resize  
In-Text Resize for Images, Tables and Fancy Resize Containers in 'shiny', 'rmarkdown' and 'quarto' Documents
Automatic resizing toolbar for containers, images and tables. Various resizable or expandable contai ...
Download / Learn more Package Citations See dependency  
HellCor  
The Hellinger Correlation
Empirical value of the Hellinger correlation, a measure of dependence between two continuous random ...
Download / Learn more Package Citations See dependency  

24,098

R Packages

207,311

Dependencies

65,069

Author Associations

24,099

Publication Badges

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