title: What is the best way to sync 2 sqlite tables over http and json?
body: <p>I have a fairly simple sync problem.  I have a table with about 10 columns that I want to keep in sync between a sqlite file on 3 different clients: an Iphone client, a browser client, and a Ruby on Rails client.  So I need a simple sycing solution that will work for all 3, i.e. I can easily implement it in Javascript, Objective C, and Ruby and it works with JSON over HTTP.  I have looked at various components of other syncing solutions like the one in git, some of the tutorials that have come out of the Google gears community, and a rails plugin called acts_as_replica.  My naive approach would be to simply create a last synced timestamp in the database and then create a changelog of all deletes as they are made. (I don't allow updates to entries in the table).  I can then retrieve all the new entries since the last timestamp, combine then with the deletes, and send a changelog as json over http between the 3 solutions.  </p>
  
  <p>Should I consider the use of SHA1 hash or a UUID of each entry or is a last synced timestamp sufficient?  How do I make sure there are no duplicate entries?  Is there a simpler algorithm I could follow?</p>