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.

In part 3 of our series on SQL databases and R, Ellis Hughes and I walk through how to set up a shiny app that queries a database based on user defined parameters from the user interface.

To watch our screen cast, CLICK HERE.

To access our code, CLICK HERE.

This week, Ellis Hughes and I continue our series on working with databases in R and build upon last week’s episode by walking you through how to set up and populate your own SQLite database from R and then run queries and aggregate functions against the data.

To watch our screen cast, CLICK HERE.

To access our code, CLICK HERE.

This week, Ellis Hughes and I kick off a new series discussing the use of SQL databases in R.

In this episode we cover a simple way to use R, more specifically the dbplyr package, to build your own SQLite database, add tables to the database, and query the database using tidyverse instead of SQL syntax.

To watch our screen cast, CLICK HERE.

To access our code, CLICK HERE.