Package: dbplyr 2.5.0.9000

Hadley Wickham

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.

Authors:Hadley Wickham [aut, cre], Maximilian Girlich [aut], Edgar Ruiz [aut], Posit Software, PBC [cph, fnd]

dbplyr_2.5.0.9000.tar.gz
dbplyr_2.5.0.9000.zip(r-4.5)dbplyr_2.5.0.9000.zip(r-4.4)dbplyr_2.5.0.9000.zip(r-4.3)
dbplyr_2.5.0.9000.tgz(r-4.4-any)dbplyr_2.5.0.9000.tgz(r-4.3-any)
dbplyr_2.5.0.9000.tar.gz(r-4.5-noble)dbplyr_2.5.0.9000.tar.gz(r-4.4-noble)
dbplyr_2.5.0.9000.tgz(r-4.4-emscripten)dbplyr_2.5.0.9000.tgz(r-4.3-emscripten)
dbplyr.pdf |dbplyr.html✨
dbplyr/json (API)
NEWS

# Install 'dbplyr' in R:

install.packages('dbplyr', repos = c('https://tidyverse.r-universe.dev', 'https://cloud.r-project.org'))

Bug tracker:https://github.com/tidyverse/dbplyr/issues

On CRAN:

database

19.90 score 478 stars 715 packages 5.0k scripts 658k downloads 4 mentions 171 exports 23 dependencies

Last updated 10 hours agofrom:d8549864c2. Checks:OK: 1 NOTE: 4 ERROR: 2. Indexed: yes.

Target	Result	Date
Doc / Vignettes	OK	Nov 12 2024
R-4.5-win	NOTE	Nov 12 2024
R-4.5-linux	NOTE	Nov 12 2024
R-4.4-win	NOTE	Nov 12 2024
R-4.4-mac	ERROR	Nov 12 2024
R-4.3-win	NOTE	Nov 12 2024
R-4.3-mac	ERROR	Nov 12 2024

Exports:%>%as_table_path as.sql base_agg base_no_win base_odbc_agg base_odbc_scalar base_odbc_win base_scalar base_win build_sql check_table_path copy_inline copy_lahman copy_nycflights13 db_col_types db_collect db_compute db_connection_describe db_copy_to db_sql_render db_supports_table_alias_with_as db_table_temporary dbplyr_edition dbplyr_pivot_wider_spec dbplyr_uncount escape escape_ansi get_returned_rows has_lahman has_nycflights13 has_returned_rows ident ident_q in_catalog in_schema is_table_path is.ident is.sql join_query lahman_mysql lahman_postgres lahman_sqlite lahman_srcs lazy_base_query lazy_frame lazy_multi_join_query lazy_query lazy_rf_join_query lazy_select_query lazy_semi_join_query lazy_set_op_query lazy_union_query memdb_frame named_commas nycflights13_postgres nycflights13_sqlite op_frame op_grps op_sort op_vars partial_eval remote_con remote_name remote_query remote_query_plan remote_src remote_table select_query semi_join_query set_op_query simulate_access simulate_dbi simulate_hana simulate_hive simulate_impala simulate_mariadb simulate_mssql simulate_mysql simulate_odbc simulate_oracle simulate_postgres simulate_redshift simulate_snowflake simulate_spark_sql simulate_sqlite simulate_teradata sql sql_aggregate sql_aggregate_2 sql_aggregate_n sql_build sql_call2 sql_cast sql_cot sql_escape_date sql_escape_datetime sql_escape_logical sql_escape_raw sql_expr sql_expr_matches sql_indent_subquery sql_infix sql_join_suffix sql_log sql_not_supported sql_optimise sql_options sql_paste sql_paste_infix sql_prefix sql_query_append sql_query_delete sql_query_explain sql_query_fields sql_query_insert sql_query_join sql_query_multi_join sql_query_rows sql_query_save sql_query_select sql_query_semi_join sql_query_set_op sql_query_union sql_query_update_from sql_query_upsert sql_query_wrap sql_quote sql_random sql_render sql_returning_cols sql_runif sql_str_sub sql_substr sql_table_analyze sql_table_index sql_translation sql_translator sql_try_cast sql_variant sql_vector src_dbi src_memdb src_sql src_test supports_window_clause table_path_components table_path_name tbl_lazy tbl_memdb tbl_sql test_frame test_load test_register_con test_register_src translate_sql translate_sql_union_query win_absent win_aggregate win_aggregate_2 win_cumulative win_current_frame win_current_group win_current_order win_over win_rank win_rank_tdata win_recycled window_frame window_order

Dependencies:blob cli cpp11 DBI dplyr fansi generics glue lifecycle magrittr pillar pkgconfig purrr R6 rlang stringi stringr tibble tidyr tidyselect utf8 vctrs withr

Adding a new DBI backend

Rendered fromnew-backend.Rmdusingknitr::rmarkdownon Nov 12 2024.

Last update: 2020-11-02
Started: 2017-04-02

dbplyr 2.0.0 backend API

Rendered frombackend-2.Rmdusingknitr::rmarkdownon Nov 12 2024.

Last update: 2022-04-28
Started: 2020-09-24

Function translation

Rendered fromtranslation-function.Rmdusingknitr::rmarkdownon Nov 12 2024.

Last update: 2024-10-31
Started: 2019-01-10

Introduction to dbplyr

Rendered fromdbplyr.Rmdusingknitr::rmarkdownon Nov 12 2024.

Last update: 2022-12-08
Started: 2017-04-02

Reprexes for dbplyr

Rendered fromreprex.Rmdusingknitr::rmarkdownon Nov 12 2024.

Last update: 2020-09-22
Started: 2019-02-05

Verb translation

Rendered fromtranslation-verb.Rmdusingknitr::rmarkdownon Nov 12 2024.

Last update: 2021-12-21
Started: 2019-01-10

Writing SQL with dbplyr

Rendered fromsql.Rmdusingknitr::rmarkdownon Nov 12 2024.

Last update: 2022-04-12
Started: 2019-02-05

Citation

Development and contributors

Readme and manuals

Help Manual

Help page	Topics
Arrange rows by column values	arrange.tbl_lazy
Backend: MS Access	simulate_access
Backend: SAP HANA	simulate_hana
Backend: Hive	simulate_hive
Backend: Impala	simulate_impala
Backend: SQL server	simulate_mssql
Backend: MySQL/MariaDB	simulate_mariadb simulate_mysql
Backend: ODBC	simulate_odbc
Backend: Oracle	simulate_oracle
Backend: PostgreSQL	simulate_postgres
Backend: Redshift	simulate_redshift
Backend: Snowflake	simulate_snowflake
Backend: Databricks Spark SQL	simulate_spark_sql
Backend: SQLite	simulate_sqlite
Backend: Teradata	simulate_teradata
Compute results of a query	collapse.tbl_sql collect.tbl_sql compute.tbl_sql
Complete a SQL table with missing combinations of data	complete.tbl_lazy
Use a local data frame in a dbplyr query	copy_inline
Copy a local data frame to a remote database	copy_to.src_sql
Count observations by group	add_count.tbl_lazy count.tbl_lazy tally.tbl_lazy
"Uncount" a database table	dbplyr_uncount
Subset rows using their positions	slice_max.tbl_lazy slice_min.tbl_lazy slice_sample.tbl_lazy
Subset distinct/unique rows	distinct.tbl_lazy
Perform arbitrary computation on remote backend	do.tbl_sql
Escape/quote a string.	escape escape_ansi sql_vector
Expand SQL tables to include all possible combinations of values	expand.tbl_lazy
Fill in missing values with previous or next value	fill.tbl_lazy
Subset rows using column values	filter.tbl_lazy
Extract and check the 'RETURNING' rows	get_returned_rows has_returned_rows
Group by one or more variables	group_by.tbl_lazy
Subset the first rows	head.tbl_lazy
SQL set operations	intersect.tbl_lazy setdiff.tbl_lazy union.tbl_lazy union_all.tbl_lazy
Join SQL tables	anti_join.tbl_lazy cross_join.tbl_lazy full_join.tbl_lazy inner_join.tbl_lazy join.tbl_sql left_join.tbl_lazy right_join.tbl_lazy semi_join.tbl_lazy
Create a database table in temporary in-memory database.	memdb_frame src_memdb tbl_memdb
Create, modify, and delete columns	mutate.tbl_lazy
Pivot data from wide to long	pivot_longer.tbl_lazy
Pivot data from long to wide	dbplyr_pivot_wider_spec pivot_wider.tbl_lazy
Extract a single column	pull.tbl_sql
Metadata about a remote table	remote_con remote_name remote_query remote_query_plan remote_src remote_table
Replace NAs with specified values	replace_na.tbl_lazy
Edit individual rows in the underlying database table	rows_append.tbl_lazy rows_delete.tbl_lazy rows_insert.tbl_lazy rows_patch.tbl_lazy rows_update.tbl_lazy rows_upsert.tbl_lazy
Subset, rename, and reorder columns using their names	relocate.tbl_lazy rename.tbl_lazy rename_with.tbl_lazy select.tbl_lazy
SQL escaping.	as.sql is.sql sql
Options for generating SQL	sql_options
Generate SQL for Insert, Update, Upsert, and Delete	sql_query_append sql_query_delete sql_query_insert sql_query_update_from sql_query_upsert
Summarise each group to one row	summarise.tbl_lazy
Use dplyr verbs with a remote database table	tbl.src_dbi tbl_dbi
Translate an expression to SQL	translate_sql translate_sql_
Override window order and frame	window_frame window_order