I have a general question on the capabilities of shiny dashboard before I embark on any development.
I have a mySQL database with employee information from several clients. It was initially for me alone to use but I have been asked to share the database with some clients. Questions as follows.
- Can R and Shiny access and tabulate, plot data in a dashboard from a mySQL database?
- Is it possible to enter or edit data back into the database from a Shiny dashboard?
- Since the database contains data from several clients is it possible to set up a login for a shiny dashboard, and restrict user access to the data.
- If any knows that this sort of thing has been done can they point me in the right direction or an example to do more research.
Thanks in advance