Re: Query database inside embedded R

Hi Stefano,

On 31 May 2016, at 11:18, Stefano Fioravanzo wrote: We are trying to transition from a Postgres database to MonetDB. We had a few R function calls, so we decided to try embedded R.

One of our R functions is designed to query the postgres database to get some more data to process. The problem, now, is how to integrate this function in Monet. We are using embeddedR to reduce latency, so using MonetDB.R inside the embedded function (if it is even possible) to query the database would be a total waste.

Clearly the ultimate solution would be to make all the queries outside the function, but it would be really really hard to achieve this result given how the function is designed.

What I am asking is the is some solution to this, like having some way to query the database inside embedded R avoiding the overhead of MonetDB.R.

Yeah that’s what I call loopback queries. We have them in embedded Python already and could possibly make them available from embedded R as well. Would you be willing to try a pre-release version of MonetDB to see whether whatever we come up with works for you? Hannes