I have a similar requirement on online / offline / sync. I am rolling something of my own; going a somewhat tried-n-true approach (use Relation DB on server exposed as Restful [POST / GET / PUT / DELETE], and assume SQLite in html5 client.)
So, I want all the complexity hides from app developer with these 4 CRUD + 2 finder methods. https://github.com/beedesk/cacheca.js I now have REST, SQLite, memory objects hide behind the interface. And, I have to use memory to cache SQLite, or SQLite to cache REST now. I will implements sync later. But, I believe it can be done later without changing anything front end. If there is enough interest, I can add some more up to date code to github, or maybe add some examples. ---------- Thomas Yip [email protected] http://beedesk.com <http://beedesk.com/> twitter: @BeeDesk From: [email protected] [mailto:[email protected]] On Behalf Of Brian McMillin Sent: Tuesday, November 02, 2010 9:33 PM To: [email protected] Subject: Re: SQLite JS Framework? Guys - I have been toying with a light-weight database design for several months. I see a need for (1) a persistent store that can (2) be used independently while off-line (thus making it useful for iPod touch and Wi-Fi-only iPad), and (3) syncs data to the cloud, and (4) merges multiple sources for collaborative usage. This is what an Exchange Server does (poorly) with tremendous overhead. I am thinking along the lines of a family's shared shopping list. I like the LawnChair link that Jesse posted. The JSON-only is very nice, and the API is clean. There is no sync/backup provision, though. You would have to roll your own, and that can get REALLY thorny. My current guess about how I will implement this is using an associative database (not relational, not SQL). This will eliminate any a-priori table structure or keys. The user is free to add fields at any time, and searches/sorts can be done efficiently on any field set. And I intend for it to be pure JavaScript, with (probably) Perl on the server side. The underlying local storage MIGHT be SQLite. Seconding Scott's comment: anyone else's thoughts or experiences would be appreciated. Brian _____ From: Jesse <[email protected]> To: [email protected] Sent: Tue, November 2, 2010 9:41:47 PM Subject: Re: SQLite JS Framework? Have a look at LawnChair for any easy storage option. http://blog.westcoastlogic.com/lawnchair/ On Tue, Nov 2, 2010 at 7:25 PM, Alex Zylka <[email protected]> wrote: I've used it a couple of times in my apps, mostly for just storing static data. I would love a JS framework, but as of now, you might want to take a look at the basics here: HTML5 DB <http://webkit.org/blog/126/webkit-does-html5-client-side-database-storage/> . Alex Zylka http://www.alexzylka.com/ http://www.zylka.us/ On Tue, Nov 2, 2010 at 1:24 PM, KCL <[email protected]> wrote: Has any written or can recommend a good, reliable and easy-to-use framework/class for managing SQLite database transactions for offline iphone/touch activity? We have a need to be able to function sans internet connection and then updating back to the servers once a connection is available. We're just now determining some of the foundations of our web app and I am looking for real-world experiences and opinions. Thanks in advance! Scott. -- You received this message because you are subscribed to the Google Groups "iPhoneWebDev" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected] <mailto:iphonewebdev%[email protected]> . For more options, visit this group at http://groups.google.com/group/iphonewebdev?hl=en. -- You received this message because you are subscribed to the Google Groups "iPhoneWebDev" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected] <mailto:iphonewebdev%[email protected]> . For more options, visit this group at http://groups.google.com/group/iphonewebdev?hl=en. -- You received this message because you are subscribed to the Google Groups "iPhoneWebDev" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/iphonewebdev?hl=en. -- You received this message because you are subscribed to the Google Groups "iPhoneWebDev" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/iphonewebdev?hl=en. -- You received this message because you are subscribed to the Google Groups "iPhoneWebDev" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/iphonewebdev?hl=en.
