scottohara/tvmanager — Issue #33: Migrate from WebSQL to IndexedDB
Author: scottohara
Created: 2011-12-22 22:52:25+00:00
State: open
Labels: Improvement

http://www.html5rocks.com/en/tutorials/webdatabase/websql-indexeddb/

As WebSQL is deprecated, we should look at moving to the NoSQL replacement: IndexedDB.

This would also tie in nicely with a proposal to change the backup/storage model from a monolithic JSON object in S3 (all programs, series & episodes) that is updated in full on every sync; to a more granular set of JSON objects (one per program) in either S3 or CouchDB that only changes are backed up.

The format of the objects stored in the front-end IndexedDB would be identical to how we'd store them in the back-end; enabling a more one-to-one approach than the current SQL <=> JSON composition.