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:
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
Last updated 18 days agofrom:1ff6363437. Checks:OK: 4 NOTE: 2 ERROR: 1. Indexed: yes.
| Target | Result | Date |
|---|---|---|
| Doc / Vignettes | OK | Sep 09 2024 |
| R-4.5-win | NOTE | Sep 09 2024 |
| R-4.5-linux | NOTE | Sep 09 2024 |
| R-4.4-win | OK | Sep 09 2024 |
| R-4.4-mac | ERROR | Sep 09 2024 |
| R-4.3-win | OK | Sep 09 2024 |
| R-4.3-mac | OK | Sep 09 2024 |
Exports:%>%as_table_pathas.sqlbase_aggbase_no_winbase_odbc_aggbase_odbc_scalarbase_odbc_winbase_scalarbase_winbuild_sqlcheck_table_pathcopy_inlinecopy_lahmancopy_nycflights13db_col_typesdb_collectdb_computedb_connection_describedb_copy_todb_sql_renderdb_supports_table_alias_with_asdb_table_temporarydbplyr_editiondbplyr_pivot_wider_specdbplyr_uncountescapeescape_ansiget_returned_rowshas_lahmanhas_nycflights13has_returned_rowsidentident_qin_catalogin_schemais_table_pathis.identis.sqljoin_querylahman_mysqllahman_postgreslahman_sqlitelahman_srcslazy_base_querylazy_framelazy_multi_join_querylazy_querylazy_rf_join_querylazy_select_querylazy_semi_join_querylazy_set_op_querylazy_union_querymemdb_framenamed_commasnycflights13_postgresnycflights13_sqliteop_frameop_grpsop_sortop_varspartial_evalremote_conremote_nameremote_queryremote_query_planremote_srcremote_tableselect_querysemi_join_queryset_op_querysimulate_accesssimulate_dbisimulate_hanasimulate_hivesimulate_impalasimulate_mariadbsimulate_mssqlsimulate_mysqlsimulate_odbcsimulate_oraclesimulate_postgressimulate_redshiftsimulate_snowflakesimulate_spark_sqlsimulate_sqlitesimulate_teradatasqlsql_aggregatesql_aggregate_2sql_aggregate_nsql_buildsql_call2sql_castsql_cotsql_escape_datesql_escape_datetimesql_escape_logicalsql_escape_rawsql_exprsql_expr_matchessql_indent_subquerysql_infixsql_join_suffixsql_logsql_not_supportedsql_optimisesql_optionssql_pastesql_paste_infixsql_prefixsql_query_appendsql_query_deletesql_query_explainsql_query_fieldssql_query_insertsql_query_joinsql_query_multi_joinsql_query_rowssql_query_savesql_query_selectsql_query_semi_joinsql_query_set_opsql_query_unionsql_query_update_fromsql_query_upsertsql_query_wrapsql_quotesql_randomsql_rendersql_returning_colssql_runifsql_str_subsql_substrsql_table_analyzesql_table_indexsql_translationsql_translatorsql_try_castsql_variantsql_vectorsrc_dbisrc_memdbsrc_sqlsrc_testsupports_window_clausetable_path_componentstable_path_nametbl_lazytbl_memdbtbl_sqltest_frametest_loadtest_register_contest_register_srctranslate_sqltranslate_sql_union_querywin_absentwin_aggregatewin_aggregate_2win_cumulativewin_current_framewin_current_groupwin_current_orderwin_overwin_rankwin_rank_tdatawin_recycledwindow_framewindow_order
Dependencies:blobclicpp11DBIdplyrfansigenericsgluelifecyclemagrittrpillarpkgconfigpurrrR6rlangstringistringrtibbletidyrtidyselectutf8vctrswithr
Adding a new DBI backend
Rendered fromnew-backend.Rmdusingknitr::rmarkdownon Sep 09 2024.Last update: 2020-11-02
Started: 2017-04-02
dbplyr 2.0.0 backend API
Rendered frombackend-2.Rmdusingknitr::rmarkdownon Sep 09 2024.Last update: 2022-04-28
Started: 2020-09-24
Function translation
Rendered fromtranslation-function.Rmdusingknitr::rmarkdownon Sep 09 2024.Last update: 2023-11-02
Started: 2019-01-10
Introduction to dbplyr
Rendered fromdbplyr.Rmdusingknitr::rmarkdownon Sep 09 2024.Last update: 2022-12-08
Started: 2017-04-02
Reprexes for dbplyr
Rendered fromreprex.Rmdusingknitr::rmarkdownon Sep 09 2024.Last update: 2020-09-22
Started: 2019-02-05
Verb translation
Rendered fromtranslation-verb.Rmdusingknitr::rmarkdownon Sep 09 2024.Last update: 2021-12-21
Started: 2019-01-10
Writing SQL with dbplyr
Rendered fromsql.Rmdusingknitr::rmarkdownon Sep 09 2024.Last update: 2022-04-12
Started: 2019-02-05
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 |
