/scodas-dbexplorer

loop over database tables using dynamic SQL via R, and and display results in shiny app

Primary LanguageRGNU General Public License v3.0GPL-3.0

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:

image

see these blog posts for further info

interpolation - what is it?

https://www.johnmackintosh.net/blog/2021-10-20-interpolation/

flexible SQL queries:

https://www.johnmackintosh.net/blog/2022-04-06-sql-schema-query/

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

https://www.johnmackintosh.net/blog/2022-04-28-purrr-sql/

opinion - keep your SQL outside your R script

https://www.johnmackintosh.net/blog/2022-02-08-separate-sql/