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. > >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]. >>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.
