On Sat, 2004-05-22 at 13:47, Puneet Kishor wrote: > On May 22, 2004, at 12:31 PM, nathanvi wrote: > > > In my office we have to share a databse (a list of addresses). > > A lot of people has a notebook. > > So my idea was: > > - a file.sqlite on the server in which all people can add, delete, > > select contacts > > - when someone have to go away, he can copy this file on his notebook > > and modify it when he is outside office > > > > The problem is when he return in office because i would like the copy > > and the original in the server are syncronized... > > Is it possible? > > Is there an utility which does it? > > I don't know of any utility that does synchronization, but I do know > that synchronization is not a simple problem. You have to make rules > for conflict-resolution when source and target are different, and just > looking at the modified date stamp might not be enough. For your > specific problem you might be better off with a tool suited for > something like this... Palm Desktop or other such address book type > programs come to mind. A database may not be the best tool for such a > thing. That said, of course, one could create a program that does such > a synchronization, but it may not be worth the trouble. > > Sorry for no encouraging answer vis a vis SQLite.
I have a similar problem; for the synchronization step of my software, the database is dumped to a text format sorting on an object id and version column, and then I use diff to produce a patch that I then simply upload. I then use rsync to download updates. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]