My current workflow in a shiny application is to run a R script as a cron job periodically to pull various tables from multiple databases as well as download data from some APIs. These are then saved as a .Rdata file in a folder called data
.
In my global.R
file I load the data by using load("data/workingdata.Rdata")
. This results in all the dataframes (about 30) loading into the environment. I know I can use the reactiveFileReader()
function to refresh the data, but obviously it would have to be used in the server.R file because of an associated session with the function. Also, I am not sure if load
is accepted as a readFunc
in reactiveFileReader()
. What should be the best strategy for the scenario here?