Hello,
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.
Thank you,
Stefano