Features

• Update to DuckDB v1.4.3, seehttps://github.com/duckdb/duckdb/releases/tag/v1.4.3 for details.

• Addstr_ilike() support (@edward-burn,#1810,#1811).

Bug fixes

• Fail with non-UTF8-encoded strings during data frame scan instead of attempting to reencode (#1795).

• Avoid inclusion of raw error message in the output.

• Fix translation ofquantile() to use DuckDB's nativeQUANTILE_CONT() syntax (#1734,#1735).

Testing

• Remove redundant R version checks from tests (#1815,#1816).

Contributors

• Update to DuckDB v1.4.2, seehttps://github.com/duckdb/duckdb/releases/tag/v1.4.2 for details.

• Update to DuckDB v1.4.1, seehttps://github.com/duckdb/duckdb/releases/tag/v1.4.1 for details.

Features

• Add support for wildcards intbl_file() paths (#1614,@rplsmn).

• Addn_distinct(..., na.rm = TRUE) support for multiple passed columns (@lschneiderbauer,#1588).

Bug fixes

• Fix Valgrind error.

Testing

• Ensure be able to install duckdb extensions on release version (@eitsupi,#1586).

Contributors

• Update to DuckDB v1.4.0, seehttps://github.com/duckdb/duckdb/releases/tag/v1.4.0 for details.

Features

• New experimentalsql_query(),sql_exec(), anddefault_conn() to simplify the most important operations for interactive use (#1564).

• tbl_file() allows omitting thesrc argument, falling back to the default connection.

• Full support for deep structs generated bystruct_pack() for ALTREP (#1545).

Bug fixes

• Fix progress display for fractional progress values (#1499,#1505).

• Extensions can be installed again.

• Update to the current v1.3-ossivalis branch, seehttps://github.com/duckdb/duckdb/tree/v1.3-ossivalis for details.

Bug fixes

• Fix timezone conversion for invalid timestamps withtz_out_convert = "force" (#1474).

• Substitute invalid UTF-8 characters in error messages to avoid a failure when reporting the error.

• Fix index calculation for retrieval of arrays (#1473).

• Fix conversion for retrieval of large enums.

• Fix compiler error in debug build (@joakimlinde,#1368).

Features

• Add rich ErrorData-based error handling with structured error information (#1479).

• Safeguard against deadlocks when accidentally issuing queries from the progress bar handler or other callbacks (#1475).

• dbGetInfo() gets the version from a hard-coded value and not from a DuckDB query (#1481).

• Package uses two cores by default for compilation (#1478).

Documentation

• Document vendoring process and main/next branch relationship (#1488).

Testing

• Addlocal_con() test fixture for cleaner DuckDB connection management (#1476).

Contributors

Features

• Update to duckdb v1.3.2, seehttps://github.com/duckdb/duckdb/releases/tag/v1.3.2 for details.

Features

• Update to duckdb v1.3.1, seehttps://github.com/duckdb/duckdb/releases/tag/v1.3.1 for details.

Bug fixes

• Correct dbplyr translations forstr_starts() andstr_ends() (#1182,#1247).

• Fix multiarch build on R 4.1 for Windows.

Features

• Update to duckdb v1.3.0, seehttps://github.com/duckdb/duckdb/releases/tag/v1.3.0 for details.

• Add ingestion of matrices (@joakimlinde,#1150).

Chore

• Fix rchk (#1173).

• Fix compiler warning (@joakimlinde,#1172).

Testing

• Skip timing tests on CRAN.

Contributors

Features

• Update to duckdb v1.2.2, seehttps://github.com/duckdb/duckdb/releases/tag/v1.2.2 for details.

• Add support for duckdb arrays in R (@joakimlinde,#102,#1090). To enable, connect withdbConnect(duckdb(), array = "matrix") (@joakimlinde,#1125).

• Support fractional seconds inTIME andINTERVAL data (#1109).

• Theautoload_known_extensions configuration option is now enabled by default (#582,#1084,#1134).

• Mention column name for conversion errors (#1108).

Chore

• Require R >= 4.1 (#1087,#1133).

• Types exposed through ALTREP are the same as through DBI (#1111), includingSTRUCT. This enables support more types in upcoming duckplyr versions.

• Perform optional checks for ALTREP compatibility inrel_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

Features

• Update to duckdb v1.2.1, seehttps://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

• Newrel_to_view() (#1075).

• New internalAltrepDataframeRelation, 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