how can I run r function from package in postgresql

Question

I am trying to use the R function from a R package (https://cran.microsoft.com/snapshot/2017-04-03/web/packages/genasis/index.html) directly in Postgres without rewriting the function again, so it could be like:

CREATE OR REPLACE FUNCTION funcname (int x,date date_start,date date_end,text input,text output,text method,int days,text pollutant, numeric temp, numeric wind))
RETURNS float AS 
The_R_fuc_result = package_name.function_name(parmas...)
  return(The_R_fuc_result)
 LANGUAGE 'plr';

I found that all cases rewrite the functions or copy pest the content of the functions. Thanks

Which function of package genasis do you want to use? The code from `AS` to `LANGUAGE` is just R code making `package_name.function_name(parmas...)` a syntax error. See [here](https://access.crunchydata.com/documentation/plr/8.3.0.18/#functions-and-arguments-a-name-functions-a) for examples — danlooo, May 13 '22 at 11:26
This function: https://github.com/cran/genasis/blob/master/R/genpastoact.R — Mazenis, May 13 '22 at 13:42
The Idea that, I do not want any R code inside the function I will call the R function through the "funcname" function. — Mazenis, May 13 '22 at 13:55

score 0 · Accepted Answer · answered May 13 '22 at 14:36

Function genasis::genpastoact expects a vector or a data frame as it first argument x. According to the documentation of plr, the type of input argument must be either scalar or binary. However, the function expects a vector here. This results in the requirement that postgress must create e.g. RDS objects. Moreover, to execute this function, you'll need not only postgress running, but also an instance of R which has the package genasis installed.

This task is not trivial. Most people would build microservices with REST APIs instead allowing sending entire tables and working with different languages for each service. This can be archived e.g. with R packages plumber, DBI and dbplyr.

how can I run r function from package in postgresql

1 Answers1