I know I can read and write data to a database using R and Shiny, and I know that Shiny is the enterprise software to deploy applications as a web page where the application can be accessed by multiple users concurrently (commercial shiny) or one user after another (free shiny). The question is the following: If the application needs to connect and read or write to a data base table, how can the concurrency control handled. Is there any code that needs to be written so that users do not interfere with each other and overwrite each other or does the shiny
software takes care of that? Could you please explain?