I have a local SQLite DB in an AIR app that I want to sync with a server MySQL one when a connection is available.
Here's what I thought of:
Timestamp each row for historic changes and send unique row IDs and timestamps to server.
Server checks for other IDs that are not in the sent list as well as existing IDs with different timestamp.
Server sends back sql queries to be run locally to update the database.
How does that look to you? I'm not happy with the last part, I think there's more info than needed being sent back.
I'd appreciate any input you might have. Thank you.
Retrieving data ...