Re: [sqlite] SQLite DB synchronization

[John LeSueur]

John Oliva wrote:
Are any of you performing synchronization between multiple SQLite DBs? 
What tools or techniques are you using?

Thanks,
John Oliva
 

That's something I'd be interested in as well.  At the moment, we are 
using a system where each table to be synchronized has at least the 
following fields:

guid (a global unique identifier, composed of a md5 hash of all the 
contained data in the row plus a couple other random bits)
date_added
date_modified

Using these, we can sync updates and inserts across database instances. 
Unfortunately, there doesn't seem to be a simple method of deleting a 
record and then syncing.
This is obviously a pretty simplistic way to do this, so any other 
suggestions I would find helpful.

John LeSueur