Kirill Müller

DO NOT MERGE: Poison re2

1

For #121.

chore: Do not include Parquet extension

2

.

Construction of deep relational trees

2

This is a toy example, but relevant for some CRAN packages with the default setting of `max_expression_depth` . The symptoms are the same as when evaluating `rel7` . Ideally, we...

Revisit `tbl.duckdb_connection()`

3

I don't understand the code and the test: https://github.com/duckdb/duckdb-r/blob/aef914bf34f4ff7dd17b3c6f5b97586f04a9c93f/R/backend-dbplyr__duckdb_connection.R#L370-L379 https://github.com/duckdb/duckdb-r/blob/aef914bf34f4ff7dd17b3c6f5b97586f04a9c93f/tests/testthat/test_tbl__duckdb_connection.R#L30-L43 I have the following questions: - What is this object cache for parquet files? - We're only executing the `PRAGMA`...

~~Starting with the relational API.~~ Opt-in for `dbGetQuery()` . The relational API and duckplyr are currently missing too many pieces.

Undefined behavior with list columns

10

To reproduce: - Clone https://github.com/krlmlr/r-4-duckdb - Run `docker run --rm -ti --platform linux/amd64 -v $(pwd):/test ghcr.io/krlmlr/r-4-duckdb:main R -q -f test/test.R` Symptoms: ``` > duckdb::dbAppendTable(con, "test_list", test_list_tbl) Error: C stack usage...

Interop with spatial extension

2

From https://github.com/duckdb/duckdb-r/issues/55#issuecomment-2012742409: Perhaps not a complete summary, but: - Right now when a database result contains a column that comes from the DuckDB spatial extension, it shows up in Arrow...

After https://github.com/duckdb/duckdb/pull/11252 . Check with valgrind on rhub2.

These belong in the `duckdb()` object and must be defined there, their presence in `dbConnect()` and their behavior causes surprises.

Excessive RAM usage for `DBI::dbWriteTable()` and `dplyr::collect()`

4

32GB RAM use when writing a 16GB file, and also RAM use reaching 32GB momentarily when reading the same 16GB file. From https://github.com/duckdb/duckdb-r/issues/72#issuecomment-1966655182, by @SimonCoulombe. ```r library(DBI) library(dplyr) library(dbplyr) library(duckdb)...