MonetDB allows to create R functions that run embedded in the database.
For example, you can do
CREATE FUNCTION rapi00() RETURNS TABLE (d INTEGER) LANGUAGE R {
seq(1,10);
};
Now, I need my users to create dynamically these user defined functions by entering R statements on a screen; the application will create the functions in the database and run them.
Problem is that R allows to run operating system level commands, such as
list.files(path=".")
or even
file.remove("some_file")
Will MonetDB allow these external interactions with the operating system, or it runs in a sandbox?