duckplyr 0.3.2 (2024-03-17)

Bug fixes

• Run autoupload in function so that it will be checked by static analysis (#122).

Features

• New df_to_parquet() to write to Parquet, new convenience functions df_from_csv(), duckdb_df_from_csv(), df_from_parquet() and duckdb_df_from_parquet() (#87, #89, #96, #128).

duckplyr 0.3.1 (2024-03-08)

Bug fixes

• Forbid reuse of new columns created in summarise() (#72, #106).
• summarise() no longer restores subclass.
• Disambiguate computation of log10() and log().
• Fix division by zero for positive and negative numbers.

Features

• New fallback_sitrep() and related functionality for collecting telemetry data (#102, #107, #110, #111, #115). No data is collected by default, only a message is displayed once per session and then every eight hours. Opt in or opt out by setting environment variables.
• Implement group_by() and other methods to collect fallback information (#94, #104, #105).
• Set memory limit and temporary directory for duckdb.
• Implement suppressWarnings() as the identity function.
• Prefer cli::cli_abort() over stop() or rlang::abort() (#114).
• Translate .data$a and .env$a.
• Strict checks for column class, only supporting integer, numeric, logical, Date, POSIXct, and difftime for now.
• If the environment variable DUCKPLYR_METHODS_OVERWRITE is set to TRUE, loading duckplyr automatically calls methods_overwrite().

Internal

• Better duckdb tests.
• Use standalone purrr for dplyr compatibility.

Testing

• Add tests for correct base of log() and log10().

Documentation

• methods_overwrite() and methods_restore() show a message.

duckplyr 0.3.0 (2023-12-10)

Bug fixes

• grepl(x = NA) gives correct results.
• Fix auto_copy() for non-data-frame input.
• Add output order preservation for filters.
• distinct() now preserves order in corner cases (#77, #78).
• Consistent computation of log(0) and log(-1) (#75, #76).

Features

• Only allow constants in mutate() that are actually representable in duckdb (#73).
• Avoid translating ifelse(), support if_else() (#79).

Documentation

• Separate and explain the new relational examples (@wibeasley, #84).

Testing

• Add test that TPC-H queries can be processed.

Chore

• Sync with dplyr 1.1.4 (#82).
• Remove dplyr_reconstruct() method (#48).
• Render README.
• Fix code generated by meta_replay().
• Bump constructive dependency.
• Fix output order for arrange() in case of ties.
• Update duckdb tests.
• Only implement newer slice_sample(), not sample_n() or sample_frac() (#74).
• Sync generated files (#71).

duckplyr 0.2.3 (2023-11-08)

Performance

• Join using IS NOT DISTINCT FROM for faster execution (duckdb/duckdb-r#41, #68).

Documentation

• Add stability to README output (@maelle, #62, #65).

duckplyr 0.2.2 (2023-10-16)

Bug fixes

• summarise() keeps "duckplyr_df" class (#63, #64).

• Fix compatibility with duckdb >= 0.9.1.

Chore

• Skip tests that give different output on dev tidyselect.

• Import utils::globalVariables().

Documentation

• Small README improvements (@maelle, #34, #57).

• Fix 301 in README.

duckplyr 0.2.1 (2023-09-16)

• Improve documentation.

• Work around problem with dplyr_reconstruct() in R 4.3.

• Rename duckdb_from_file() to df_from_file().

• Unexport private duckdb_rel_from_df(), rel_from_df(), wrap_df() and wrap_integer().

• Reexport %>% and tibble().

duckplyr 0.2.0 (2023-09-10)

• Implement relational API for DuckDB.

duckplyr 0.1.0 (2023-07-03)

Bug fixes

• Fix examples.

Chore

• Add CRAN install instructions.
• Satisfy R CMD check.
• Document argument.
• Error on NOTE.
• Remove relexpr_window() for now.

Documentation

• Clean up reference.

Uncategorized

Initial version, exporting: - new_relational() to construct objects of class "relational" - Generics rel_aggregate(), rel_distinct(), rel_filter(), rel_join(), rel_limit(), rel_names(), rel_order(), rel_project(), rel_set_diff(), rel_set_intersect(), rel_set_symdiff(), rel_to_df(), rel_union_all() - new_relexpr() to construct objects of class "relational_relexpr" - Expression builders relexpr_constant(), relexpr_function(), relexpr_reference(), relexpr_set_alias(), relexpr_window()