duckdb-r

duckdb-r copied to clipboard

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

krlmlr

Expose the internal default connection and `sql` function?

4

The `sql` function used internally would be useful to perform processing via DuckDB. (e.g., reading Parquet files). https://github.com/duckdb/duckdb-r/blob/d243b5301bdca5e642a4579ced6fd7f7b9ded04e/R/sql.R#L1-L15 Would you consider exporting this with a name like `duckdb_query`?

eitsupi

Make `duckdb_register` as a generic function

5

Currently there is a separate function named `duckdb_register_arrow` available apart from `duckdb_register`, but I am wondering if these can be made into one S3 generic function.

eitsupi

"Out-of-tree-extensions" missing for Windows

7

Hi, Thanks for all the great work on maintaining this package. I can interpret from the work being done on 0.10.0 that this requires some effort, but it's greatly appreciated....

thohan88

duckdb R client uses excessive RAM and crashes

48

#### What happens? duckdb crashes when trying to perform queries on a large (~150 GB) parquet database #### To Reproduce Apologies I cannot reproduce this with a smaller dataset. I...

cboettig

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

krlmlr

The relevant info can also be hard-coded in the R code. https://github.com/duckdb/duckdb-r/pull/73#issuecomment-1962439369

krlmlr

Instead of : ```r con

romainfrancois

Error: Invalid Input Error: Invalid unicode (byte sequence mismatch) detected in segment statistics update

5

hi, i'm still hitting [this error](https://github.com/duckdb/duckdb/issues/1650) on both the CRAN version and also the `duckdb_0.8.1-9000` dev version.. # using github remotes::install_github("duckdb/duckdb-r") # minimal reproducible example library(duckdb) con con my_df dbWriteTable(...

ajdamico

any tricks to speed up install time

4

Any known tricks to speed up install time? Also this that happens during R CMD check ``` * checking whether package 'duckdb' can be installed ... [35m/35m] OK ``` 35...

jangorecki