[jQuery] Re: OT: AIR sync?
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
[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
[jQuery] Re: OT: AIR sync?
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
[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
[jQuery] Re: OT: AIR sync?
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
[jQuery] Re: OT: AIR sync?
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
[jQuery] Re: OT: AIR sync?
Mostly. Using Blaze allows you to communicate via remoting, which is a binary protocol. It's faster and lighterweight. However, the data sync is where LCDS really gets it's muscle. andy _ From: jquery-en@googlegroups.com [mailto:jquery...@googlegroups.com] On Behalf Of Jack Killpatrick Sent: Friday, March 27, 2009 4:24 PM To: jquery-en@googlegroups.com Subject: [jQuery] Re: OT: AIR sync? 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
