search

yaronkoren / miga

A Javascript application (with some PHP) for viewing and browsing arbitrary structured data
GNU General Public License v3.0
20 stars 7 forks source link

Revisit IndexedDB? #26

Open jqnatividad opened 9 years ago

jqnatividad commented 9 years ago

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 commented 9 years ago

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 commented 9 years ago

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.