I have a project for an e-commerce company that involves downloading data via various API's and storing the data in a database. After that, people in the company are going to need to view and edit the data (think of setting prices and running sales), and other partners are going to need to access the data via our own API.
Just to see how all the parts work together, I'm using R and duckdb to figure out how all the API calls work, how to transform the data, and how to parse it out into various relational database tables.
Now I'm wondering if I can just use this setup once we go live, or will I have to either switch to AWS (or the equivalent)? That is, can the R/Shiny environment handle the security, authentication, authorization, data interaction (nothing too fancy, just filter, sort and edit) and outside API access that the project requires?
If anyone has done this in the past, please let me know. Or if I need to use "real" database tools to finish the project, I should know that now so I can start investing my research time elsewhere.
Many thanks for any help or suggestions.