Continuing with our work on accessing a SQL database via R, Ellis Hughes and I deal with one of the more commonly faced problems — getting your {shiny} app to automatically update when something in the database changes!
We walk through setting up the {shiny} server so that it checks the database for any new data, pulls the new data and automatically refreshes the {shiny} app without disturbing whatever the user is looking at. This set up will ensure that your end users are always viewing the most up to date data in your system.
To watch the screen cast, CLICK HERE.
To access our code, CLICK HERE.