scodas-dbexplorer

code for SQL queries to loop over database tables, and shiny app to display / monitor values, presented at SCODAS meeting 2022-06-14

N.B. - there are 2 versions of the app.
The version demonstrated, which has one dashboard tab, is in the main branch.

Use the app-with-metadata branch for revised layout, featuring an additional tab and table which displays metadata about the current selected table.

See the screenshot below to navigate to the app-with-metadata branch:

see these blog posts for further info

interpolation - what is it?

https://johnmackintosh.com/archive/interpolation/

flexible SQL queries:

https://johnmackintosh.com/archive/sql-schema-query/

the code you need for the back end of the app:

https://johnmackintosh.com/archive/purrr-sql/

opinion - keep your SQL outside your R script

https://johnmackintosh.com/archive/separate-sql/