Revisit IndexedDB?

[jqnatividad]

It now appears that IndexedDB is supported across all major browsers (http://caniuse.com/#search=indexeddb)

For the most part, one installation we had was very happy with MigaDV. Except, as you well know, most enterprise environments are still Windows. We created workarounds (detect browser, redirect to a static page; created a user-friendly way to install chrome with an extended installer, etc), but it was the main thing they had an issue with.

I realize it will be non-trivial though as WebSQL is relational, and IndexedDB is a kv-store, so all the dynamic sql generation for faceted searching will have to be re-implemented.

[yaronkoren]

That's basically been true for a while... the issue was never with support for IndexedDB, it was that IndexedDB is (in my opinion) poorly suited for the task. Google has a very new project out, called "Lovefield", that is basically intended to let IndexedDB function more like Web SQL:

http://google-opensource.blogspot.ca/2014/11/lovefield-powerful-javascript-sql-like_17.html

It looks pretty complicated to set up, but I do hope to look into it at some point.

[jqnatividad]

Awesome! Lovefield looks promising, and the fact that Google is behind it and is already using it for an app in the field is reassuring.

IMHO, abandoning WebSQL in favor of IndexedDB largely because of strict licensing requirements really crippled HTML5 storage, and it's frustrating that we need to fake-SQL with Rube-Goldberg mechanisms like this.