I would like to find the best way to solve the following problem:
I need a database for a software. The software needs to use the data to populate the UI and allow the user to interact with them (edit, add, delete etc). There are multiple instances of that software (desktop, mobile, another desktop etc) all linked to the same account with the same data.
I need a way to have up-to-date databases between the instances. One way is to have the data on the cloud, and then have the software pull/push data to it and maintain their own local database.
Is there a convention in the industry of how to do this kind of things? I am using AWS and I consider either DynamoDB or traditional SQL databases.