User Defined Functions with R about duckdb-r HOT 3 OPEN

A while back I was involved in implementing Arrow UDFs and the challenge was basically that R code must execute on the same thread, so there is a slightly awkward dance where whenever Arrow does something that might execute some R code (like a user-defined function), we have to launch a thread to do "do arrow stuff" and run an event loop on the R thread that waits for R tasks that need executing on the other thread.

Some (not so) light reading that might be relevant (I am not sure how similar DuckDB UDFs are to Arrow UDFs):

https://github.com/apache/arrow/blob/fd11b7a042f0a020a0cde34e043ad2e77752bca6/r/src/safe-call-into-r.h

https://github.com/apache/arrow/blob/fd11b7a042f0a020a0cde34e043ad2e77752bca6/r/src/compute.cpp#L633-L788

from duckdb-r.

I'm just here to lend my support.

I'm building shiny apps with duckdb back ends and it would be so fantastic if we could get R UDFs.

from duckdb-r.

coming back to this. Yes I think happy to contribute as well.

@paleolimbot do you have any PR for other duckdb features similiar to this that potentially itnerested contributors can get a glimpse at just to try to understand at a high level the work that would have to happen for this?

from duckdb-r.