I guess the key is that apps are able to track all changes of their data, so either the database keeps logs of every changes or never modify existing data but add a new one, have apps to calculate the final state of data.
I tried PouchDB and CouchDB which most of time are working well except conflicts of data repeatedly occurs.