Duckdb 0.10.0 (stable) Release for R ?

[clementlefevre]

Hello, first thanks for this amazing package.
Before the 0.10.0 (stable) version had i silent errors when exporting a MariaDB Table into Duckdb :

LOAD mysql;
ATTACH 'host=127.0.0.1 user=username password=pwd port=0 database=db_name port=3306' AS mysqldb (TYPE mysql, READ_ONLY);
CREATE OR REPLACE TABLE %s AS SELECT * FROM mysqldb.%s;

Resulted in duckDB tables with some empty values.

Since the 0.10.0 (stable) it does work using the duckDB CLI.
But as the .duckdb file format generated by the 0.10.0 (stable) version is not recognized by the duckDB R package version duckdb_0.9.2-1, i have to export the tables to parquet and then instantiate a new duckDB instance importing those parquet files:

> con <- dbConnect(duckdb("mydb.duckdb", read_only = TRUE))
Error in h(simpleError(msg, call)) : 
  error in evaluating the argument 'drv' in selecting a method for function 'dbConnect': rapi_startup: Failed to open database: Serialization Error: Failed to deserialize: field id mismatch, expected: 201, got: 103

Any chance we get a 0.10.0 (stable) compatible package in R ?

Thanks a lot in advance.

[Tmonster]

Hi @clementlefevre,

We are working on getting a duckdb-r v0.10.0 package up in the next couple of days. Hopefully it won't be too long.

[krlmlr]

Currently blocked by a regression in the duckdb core. CC @hannes.

Reference: duckdb/duckdb#10245 (comment), #86

[stefanfritsch]

Thanks for the update!

[szarnyasg]

DuckDB 0.10.0 is now available on CRAN: https://cran.r-project.org/web/packages/duckdb/index.html