AS3 / Air iOS和Android数据将数据同步到多个设备到远程数据库

Question

I am about to undertake the development of an app that requires sycning of data from the local device to an online DB...and back.

I am building something that will allow users to create events and invite users to those events. Users will also be able to chat and receive in app notifications. I would like to store the information in local storage that the user creates and push this information to an online DB when there is internet available. Then if there are any waiting events or notifications for that user, they can retrieve them when online also.

My concern is about the merging of data and the fact the local storage PK's will not be the same as the online PK's.

For example, user1 and user2 both just installed the app. They both create an event and invite each other to the event. Once they are both online their devices try to push the data to the online DB however there is a conflict with the PK used.

My question is: Can someone give me some guidance about how best to handle a situation like this? The app will be built using AS3 and Air and only for iOS and Android. There will be a MySQL remote DB with a PHP backend.

Any help is appreciated.

Answer 1

You could also send a time stamp of when it was sent to use with your PHP, where the request that got there last has an event sent back to notify the user (probably best with a push notification) that there has already been an event made.

Also not sure if you know already, but you can use NetConnection status to get a sense of when they connect to the internet.

localNc = new NetConnection();
localNc.addEventListener(NetStatusEvent.NET_STATUS, netStatus);

function netStatus(event:NetStatusEvent):void{
    trace(event.info.code);
}