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]

Reply via email to