Suggestions for synchronized database
<p>I have not yet implemented any portion of code to deal with this topic. I am looking to get suggestions on the best way to execute the task at hand. To simplify:</p>

<p>My application stores data in a local SQLite database. I want to be able to share this database with other people for public access. I was thinking about uploading a copy of the database file to a server, and then allowing other people to copy the database to their devices, make changes, and then replace the file on the server. I want to avoid maintaining a database on the server (the server's only purpose is to hold the shared db file (no operations whatsoever server-side)).</p>

<p>A major issue that might arise is: Two users making changes to separate copies of the db will cause data to be lost if each user makes separate modifications and both upload and overwrite to the same file. How would I allow multiple users at any given time to modify the shared file and everyone always has the same data on their device?</p>

<p>However, it doesn't have to be with using a server and file ul/dl. The application could send out notifications to all the synchronized devices informing them on the specific record changes.</p>

<p>I am not sure which direction to choose. Any help is greatly appreciated.</p>
