This may be a popular question, But i am new to synchronization concept. Please guide me with suggestions.
My requirement is to have a local and remote database(cloud) to sync the data between them. I am creating a mobile app and desktop app to access the same database for data sync. But mobile and desktop app will have a local database similar to the database schema which is running in remote in case of no internet connectivity. When internet connectivity happens, the changes made in local database has to sync with remote database or vice versa. I am developing the desktop application in Javafx and mobile app in iOS and Android in Objective C and Java respectively.
How can i achieve this database synchronization?
When i googled, i found that database replication works for this scenario. I am thinking of using Couchdb for both remote and local database. Will Couchdb supports this type of database synchronization?