Unable to build 0.10.0 from source for windows for R 4.1.2 about duckdb-r HOT 7 OPEN

Thanks. Is it difficult for you to upgrade to R 4.3?

from duckdb-r.

Unfortunately it is at this time, but it may happen in the future.

The issue I was trying to deal with, that I posted about on stackoverflow (https://stackoverflow.com/questions/78187731/support-microseconds-when-storing-posixct-column-in-duckdb-file) I was able to work around by writing wrapper functions that converts the posix columns into numeric before writing and then back to posix after reading.

I didn't bother posting that as an issue since it's such an old version (0.7-1) and I see that there are several new data types that have been introduced by the time it got to 0.10.

Luckily the workaround is getting the job done for now!

from duckdb-r.

Thanks. What workaround do you refer to?

from duckdb-r.

It seems more difficult than anticipated to build for R < 4.2 on Windows.

from duckdb-r.

Thanks. What workaround do you refer to?

Writing POSIXct columns to a duckdb file were having their subseconds stripped. The workaround I am using is to convert those columns to numeric before writing them to the duckdb file, and then converting them back to POSIXct after reading in the data.

from duckdb-r.

Can you please try from the current v0.10.1 tag?

498dc55

from duckdb-r.

@JamesLMacAulay: are you still experiencing problems building duckdb from source?

from duckdb-r.