I have a shiny app that will be hosted on a server at my work. I use a global file to connect to a postgres DB and query the appropriate data. When I update the database with new data or changes I would like to have those changes be reflected in shiny app.
I know in order for that to happen I would need to move the database queries into the server as reactive expressions or have the IT personel set the app to redeploy every couple days, which would affect my caching. I have many queries and worried about performance issues if the queries are executed on fresh inputs in reactive statements.
Is there a work around to have the global.R file refresh manually or automatically once it is deployed?
Mostly curious about the questions below
**I have seen examples by creating an actionButton and using session$reload() as stated here. Does restarting the session reload the global? for all users or only that user?
Or is another option using a restart.txt file with an action button as stated here**
