Tomas, I'd love to see it. Sounds like a great solution.
-Lee On Wed, Nov 3, 2010 at 1:41 AM, Thomas Yip <[email protected]> wrote: > 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 > > 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]<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]<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]<iphonewebdev%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/iphonewebdev?hl=en. > -- -Lee Andron 617-272-0936 http://www.linkedin.com/in/andron -- 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.
