Re: [sqlite] SQLite DB synchronization

2004-08-11 Thread John LeSueur
John Oliva wrote: I haven't worked out a synchronization scheme yet. One possibility is to model it on how the Palm PDB databases are synchronized. They keep meta-data for each row indicating whether the data is dirty, new, has been deleted, etc. This is optimized for a one-to-one pairing between

Re: [sqlite] SQLite DB synchronization

2004-08-11 Thread John Oliva
I haven't worked out a synchronization scheme yet. One possibility is to model it on how the Palm PDB databases are synchronized. They keep meta-data for each row indicating whether the data is dirty, new, has been deleted, etc. This is optimized for a one-to-one pairing between two databases. A

Re: [sqlite] SQLite DB synchronization

2004-08-10 Thread 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 follow

[sqlite] SQLite DB synchronization

2004-08-10 Thread John Oliva
Are any of you performing synchronization between multiple SQLite DBs? What tools or techniques are you using? Thanks, John Oliva