Offline storage solutions

May 24, 2011 at 3:12 PM

I would like to start a discussion looking at the different offline storage solutions.  The presentation mentioned quite a few (db40, perst, sterling, sqlite etc.)  I'm also particularly interested in the HTML 5 offline storage solutions to see how difficult it would be to build a lot of the same concepts into a HTML 5 solution.  Obviously the programming model would be different (JavaScript), but is it even realistic to try and accomplish the same using a HTML 5 solution?

So if we use the canonical requirements mentioned in the presentation for Local Storage, how do the different solutions compare against it?

  • Persistence - survive app restarts
  • Indexed - data grows quickly, need quick access
  • Disk Paging  - only pull what you need from disk
  • Relationships & Graphs
  • Locking - multi threaded/app access
  • Transactions
  • Programming Model (T-SQL, LINQ, ...)

Anybody?   Thanks

May 25, 2011 at 11:34 AM

I've spend some time investigating the HTML 5 offline storage space yesterday and just want to posted some links for other people to use as well:

  1. Presentation Slides from a Google Employee on the HTML 5 Storage solutions - requires Google Chrome/Safari to view
  2. Blog post by Pablo Castro about MS's vision for HTML 5 DB Solutions
  3. Javascript Indexed DB samples for upcoming IE support