Local/Remote Data

[Ruslan Zasukhin]

on 10/11/03 13:28, Ian Devaney at idevaney at mac.com wrote:

Hi Ian,

> 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?

Why not to use Valentina Server also?
 
Do you want synchronization in both directions?

Yes, such column and its value they name TIMESTAMP.
It should be better ULLONG field.

> 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.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------