It's possible I suppose. The problem is that the cost for LCDS (to get the data syncing) might be prohibitive for your project. You could also work with BlazeDS which has much of the same functionality of LCDS (a little brother of sorts).
I've not personally done any data snycing so I'm not speaking from experience. How I might approach it though is to store a set of SQL scripts in the AIR app to get the timestamps from the local SQLite db. Stash the "last synced" timestamp on the file system (or in a table in the db locally). Then compare when needed with the remote database. The syncing is going to be the hard part though. Possibly you could add a column in both dbs which contained a "last changed" data. Then, you could also query against the "last changed" between the AIR app and the remote db. andy -----Original Message----- From: jquery-en@googlegroups.com [mailto:jquery...@googlegroups.com] On Behalf Of Jack Killpatrick Sent: Friday, March 27, 2009 2:38 PM To: jquery-en@googlegroups.com Subject: [jQuery] Re: OT: AIR sync? We've looked at LCDS, but aren't too keen on using Flex for the UI. Maybe there's some minimal way we could use it just for the sync aspect (ie as more of an internal thing)? That would be fine. - Jack Andy Matthews wrote: > It sounds like you've already made up your mind about using HTML/JS > (my personal choice), but have you considered Flex in conjunction with > LiveCycle Data Services? LCDS makes syncing and managing conflicts SUPER simple. > > > andy > > -----Original Message----- > From: jquery-en@googlegroups.com [mailto:jquery...@googlegroups.com] > On Behalf Of Jack Killpatrick > Sent: Friday, March 27, 2009 1:06 PM > To: jquery-en@googlegroups.com > Subject: [jQuery] OT: AIR sync? > > > Sorry for the slightly off topic post, but I know there are some AIR > devs on this list and someone might have a tip for me. > > I'm planning an Adobe AIR app that will be written with HTML/jQuery > and needs to do offline sync (using SQLite db on AIR side, mysql on > server side and json web services). IE: an online user must be able to > sync their SQLite db from the server, disconnect, modify records, then > reconnect and sync back to the server, with any conflicts (due to > someone else changing the same record since they last got it) raised > so that we can notify the user and offer a conflict resolution dialog. > > I've googled around a bunch, but am not finding much (about best > practices, or opensource code to help me along, or 3rd party products > to help). We have experience doing sync in other projects, just not in > AIR, so are doing some fishing. > > If anyone has some links, advice, etc, thanks in advance! > > - Jack > > > >
