Well, to keep this going, here is a recent post with an R Shiny app made specifically for database interactions. If anyone comes across this post in the future, I'm not saying this is the only/best way to do it, but at least this is a working (and very good looking) example!