Thanks, Andy. I haven't been able to find pricing for LCDS, which makes
it hard to consider (without a ballpark, at least). Looks like it's an
enterprise-sale kind of thing, but if you know otherwise, do tell ;-)
The client-server sync, conflict resolution and offline data cache
*does* sound about right for what we'd need, based on this:
http://www.adobe.com/products/livecycle/dataservices/features.html
There's mention in there of ajax date services, too, but nothing
specifically about how it might tie into the sync stuff.
Thanks for the design thoughts... that's roughly what we're thinking,
too (check timestamps, do something). It's unclear to me at this point
what the "high-performance data sync engine" in LCDS would supply.
Taking a look at BlazeDS. I see that an Ajax client library can be used
to talk to the BlazeDS server. Know how stable BlazeDS is?
- Jack
Andy Matthews wrote:
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