I work for an insurance company. They have a contact database that gets pushed to the field agents by Lotus Notes. We’re trying to move away from Lotus Notes, but we first have to remove our dependency on it.
It has been suggested that a HTML5 solution could provide offline access to agent contacts and be used to sync changed from the server down and the client up.
It is my understanding that the SQL storage capabilities of HTML5 aren’t fully implemented (IE and Firefox apparently don’t support yet per one site I read.) LocalStorage may not be robust enough for the data we need to sync since the size limit is relatively small.
Is HTML5 a feasible solution to this issue or should we track down some kind of syncing solution? (I’ve been reading about one from the Ubuntu folks and Microsoft’s, as well.)
Thanks!
3
Check out caniuse.com. For WebSQL, it’s deprecated:
However, if key-value stores are an option that might do:
Also check out this great listing of options.
1
In short: Your question seems to be discussed with pros and cons in the following SO posts. Look at the following references:
- Best way to synchronize local HTML5 DB (WebSQL Storage, SQLite) with a server (2 way sync)
- Offline storage – db sync
- How to synchronize HTML5 local/webStorage and server-side storage?
I would add my 2 cents with pointing to the security concern of letting collected data to remain un-encrypted in local storage. Because the way how data is collected in a device/tablet may have some personal/commercial sensitive data whose storage should comply with varies compliance rules.
2