Local/Remote Data

[Ian Devaney]

This is a copy of a message I sent to the RB list and I was wondering 
if there are also any special considerations regarding Valentina I 
should be thinking about.

Just to clarify, the mySQL database will essentially be used as a 
central dumping ground for data that would then be downloaded to each 
user's application/Valentina db.

Also, there is the obvious question:

Is this a stupid idea and are there better ways of achieving the same 
thing?

Cheers,

Ian

 >>>>>>>

My next project is an application that will store data both locally on 
the user's Mac (Valentina) and remotely in an on-line database (mySql).

Several users will be accessing the system.

I want to implement a "sync" system whereby the user synchronizes the 
data on the local machine with the remote whenever they feel it is 
necessary.

My first thought on this was to include a "sync code" integer column in 
each table.

This would be incremented every time an item is edited.

When the application compares the local db to the remote, it would look 
at these two values and if one is greater than the other it would 
update the corresponding record.

Is this way too simple? It certainly feels like it!

Any help would be much appreciated.

Thanks,

Ian