Releases: duckdb/duckdb-r
duckdb 1.2.2
Features
-
Update to duckdb v1.2.2, see https://github.com/duckdb/duckdb/releases/tag/v1.2.2 for details.
-
Add support for duckdb arrays in R (@joakimlinde, #102, #1090). To enable, connect with
dbConnect(duckdb(), array = "matrix")(@joakimlinde, #1125). -
Support fractional seconds in
TIMEandINTERVALdata (#1109). -
The
autoload_known_extensionsconfiguration option is now enabled by default (#582, #1084, #1134). -
Mention column name for conversion errors (#1108).
Chore
-
Types exposed through ALTREP are the same as through DBI (#1111), including
STRUCT. This enables support more types in upcoming duckplyr versions. -
Perform optional checks for ALTREP compatibility in
rel_from_df()andexpr_constant()(#1117). -
Perform time zone conversion in the C++ layer where possible, to support ALTREP (#1130).
-
Improve developer experience:
pkgload::load_all()now works, source files are rebuilt if header files change, configure clangd (#1128). -
Add dots with checks to unexported functions (#1115).
-
Clean up edge case for fetching zero rows (#1104).
-
Avoid test for timings on CRAN (#1101).
Documentation
- Tweak README.
Contributors
Assets 2
duckdb 1.2.1
Features
- Update to duckdb v1.2.1, see https://github.com/duckdb/duckdb/releases/tag/v1.2.1 for details.
Bug fixes
-
dbExecute(con, "CALL ...")no longer attempts to access the resulting data frame. UsedbGetQuery(con, "CALL ...")to access the data (#1062, #1080). -
Fix support for the connections pane in RStudio and Positron (@dfalbel, #1063).
Internal
-
New
rel_to_view()(#1075). -
New internal
AltrepDataframeRelation, used withrel_from_altrep_df(wrap = TRUE)(#949, #1072). -
Try relational materialization only once (#1066).
Chore
-
Update vendored cpp11 to 0.5.2 (#1068).
-
Avoid calls to non-API R functions.
Contributors
Assets 2
duckdb 1.2.0
Breaking changes
- Breaking change: Remove substrait API:
duckdb_get_substrait(),duckdb_get_substrait_json(),duckdb_prepare_substrait(),duckdb_prepare_substrait_json()(@pdet, #1021).
Features
-
Update to duckdb v1.2.0, see https://github.com/duckdb/duckdb/releases/tag/v1.2.0 for details.
-
Floor sub-day precision date before casting to int (@toppyy, #517, #981).
-
Set value returned by
PRAGMA user_agentto r-dbi (#707, @elefeint).
Bug fixes
-
Remove unconditional use of
CPPHTTPLIB_USE_POLLto support compilation with R 4.0 and R 4.1 again (@Antonov548, #1043). -
Support reading from multiple Parquet files again (#1015, #1024).
-
Fix translation for
add_days()andadd_years()clock functions (#976, @IoannaNika).
Contributors
Assets 2
duckdb 1.1.3-2
Bug fixes
Chore
- Sync vendoring script with igraph (#936).
Features
-
Limit automatic materialization by number of rows or number of cells (#1017).
-
New internal
rapi_rel_to_csv(),rapi_rel_to_table(), andrapi_rel_insert();rapi_rel_to_parquet()gainsoptionsargument (#867).
Testing
-
Skip tests that are about to fail.
-
Sync tests.
duckdb 1.1.3-1
Features
-
With
duckdb(environment_scan = TRUE), data frame objects are available as views in duckdb SQL queries (#140, #164). -
Update vendored cpp11 to 0.5.1 (#636).
Bug fixes
-
Make
./cleanupscript reentrant (@Antonov548, #612, #634). -
Fix installation of extensions (#623).
-
Fix rchk and UB errors (#635).
-
Avoid loading rlang during startup (#601).
Documentation
- Mention
xzrequirement inDESCRIPTION.
Contributors
Assets 2
duckdb 1.1.3
Features
-
Update to duckdb v1.1.3, see https://github.com/duckdb/duckdb/releases/tag/v1.1.3 for details.
-
New
duckdb.materialize_callbackoption, supersedesget_last_rel()(#589). -
New
rel_explain_df()andrel_tostring()(#587). -
Handle empty child values for list constants (#186, @romainfrancois).
Chore
Contributors
Assets 2
duckdb 1.1.2
Features
- Update to duckdb v1.1.2, see https://github.com/duckdb/duckdb/releases/tag/v1.1.2 for details.
Features
-
Long-running queries can now be canceled immediately with Ctrl + C (terminal) or Escape (RStudio IDE and Workbench) (#514, #515).
-
Add
col.typesargument toduckdb_read_csv()(#445, @eli-daniels). -
Rethrow errors with rlang if installed (#522).
-
Improve error message for parsing erros during statement extraction (tidyverse/duckplyr#219, #521).
Bug fixes
-
Avoid RStudio IDE crashes when ending session with open objects (#520).
-
rfunsextension:%in%works correctly as part of a&conjunction (#528).
Internal
Contributors
Assets 2
v1.1.0
What's Changed
- feat!: Rename
tbl_query()totbl_function(), removetranslate_duckdb()by @krlmlr in #211 - feat: New
rel_from_sql()by @krlmlr in #212 - ci: Various enhancements towards supporting protected branches and auto-merge by @krlmlr
- feat:
n_distinct()supportsna.rm = TRUEwith a single vector argument again by @lschneiderbauer in #216 - fix: Correctly compute vector length for data frames passed to relational functions by @krlmlr in #379
- feat: Tweak implementation of
r_base::sum()by @krlmlr in #385 - feat: Reduce size of binary package for Linux on Posit Package Manager by @krlmlr in #386
- feat: Bump vendored cpp11 to v0.5.0 by @krlmlr in #387
Full Changelog: v1.0.0-2...v1.1.0
Contributors
Assets 2
v1.0.0-2
v1.0.0-1
What's Changed
- Upgrade vendored cpp11 to 0.4.7 to fix compilation with R-devel.
- fix: Support new
I()syntax from dbplyr by @krlmlr in #195
Full Changelog: v1.0.0...v1.0.0-1