Hello! I made a shiny app that pulls data from a .csv in order to let users dynamically select data from it and make visualizations. My goal is to translate the shiny app to pulling data that's formatted the same way from a SQL database. I've done some reading but am not very experienced with SQL, so please pardon the broadness / noobness of these questions:
Will the shiny app need its own container? Can it be hosted on the same server as the database with a SQL or API connection?