Thanks for the info. I took a look a BlazeDS and it looks like it's just
a messaging system for Flex-to-Java/services messaging (or
js-to-flex-to-java via js bridge), not anything specific for db
manipulation or sync. Did I read it right?
- Jack
Andy Matthews wrote:
I don't know the current version, but my company was willing to put
the initial release into production for using in a broadcasting
application AIR app that I wrote in jQuery/HTML, sort of a one way
instant messenger. It seemed very stable at the time, and that was
almost a year ago.
It's a pretty cool thing, but don't let their marketing chatter about
"push" kid you. It's polling plain and simple. That's "okay", but not
really what they advertise it as.
One thing I'll warn you of. If you end up using BlazeDS I discovered a
bug where transparent HTML AIR apps would not function if you used
BlazeDS. Turn transparency off and it worked just fine.
andy
------------------------------------------------------------------------
*From:* jquery-en@googlegroups.com [mailto:jquery...@googlegroups.com]
*On Behalf Of *Jack Killpatrick
*Sent:* Friday, March 27, 2009 3:13 PM
*To:* jquery-en@googlegroups.com
*Subject:* [jQuery] Re: OT: AIR sync?
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
