duckdb-r

duckdb-r copied to clipboard

The man page for `backend-duckdb` contains documentation for `simulate_duckdb`, `translate_duckdb`, `tbl_file` and `tbl_query`. The examples for this man page do not reference any of the functions that are documented in...

JosiahParry

Thanks for your great work on this package! I get this error when trying to read a table into R and a string includes `\x0`, such as in row 201753...

vincentarelbundock

Error Writing Encrypted Parquet Files on Windows

2

I'm trying to execute the code below on Windows (I'm on Windows 11): ```r # sample keys key1

yng-me

parameters passed using dbConnect( config = list() ) are ignored

9

Hi, I saw some code ([here](https://github.com/duckdb/duckdb-r/issues/72#issuecomment-1936461870)) that used config=list() to pass parameters to a duckdb connection. I tried it, but for me, they are ignored as illustrated below where the...

SimonCoulombe

`round()` semantics of R-version differs from its duckdb-translation

1

In the current state of duckdb-r, the `round()` semantics of R-version differs from its duckdb-translation in case where the rounded digit is "5". See the difference in the following reprex:...

lschneiderbauer

Install extension when using webr

11

It seems that when installing a duckdb extension (like httpfs) using [r-wasm/webr](https://github.com/r-wasm/webr) and [coatless/quarto-webr](https://github.com/coatless/quarto-webr) duckdb should use HTTPS for the connection to work. However it currently uses plain HTTP http://extensions.duckdb.org/...

dicorynia

add `temporary` parameter to `duckdb_read_csv()`

3

It is currently not possible to write a temporary table using `duckdb_read_csv()` directly. To fix this, can we expose the `temporary` parameter in `duckdb_read_csv()`: https://github.com/duckdb/duckdb-r/blob/b13d4050e3096c38a699719a2b5e89fc65106765/R/csv.R#L32-L33 and pass it to the...

ThomasSoeiro

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...

krlmlr

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`...

krlmlr

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

krlmlr