Skip to content

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

License

Notifications You must be signed in to change notification settings

johnmackintosh/scodas-dbexplorer

Repository files navigation

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/

About

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

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages