4

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!

Improve this question
3
  • 1
    I found this chart. It's kind of handy! caniuse.com/sql-storage
    – Darkwater23
    Feb 15, 2013 at 19:50
  • Is there a reason why you're creating something like this on your own? There are many products that manage contacts and distribute them to users. Salesforce comes to mind. Their next version of their mobile app should have off-line capabilities.
    – JeffO
    Feb 24, 2016 at 18:45
  • Have you looked into pouchdb?
    – Esben Skov Pedersen
    Feb 24, 2016 at 20:10

2 Answers 2

Reset to default
7

Check out caniuse.com. For WebSQL, it's deprecated:

enter image description here

However, if key-value stores are an option that might do:

enter image description here

Also check out this great listing of options.

Improve this answer
1
  • 1
    To be fair, all that chart says is that Microsoft and Mozilla never implemented WebSQL. Wikipedia says that the working group stopped working on the specification because nobody bothered to come up with implementations that competed with SQLite. IndexedDB does a bit better than WebSQL, if you don't mind it being buggy on a Mac.
    – Robert Harvey
    Feb 24, 2016 at 16:04
6

In short: Your question seems to be discussed with pros and cons in the following SO posts. Look at the following references:

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.

Improve this answer
2
  • 2
    Encryption is the very next requirement. The one after that is remote wiping of data. :P
    – Darkwater23
    Feb 15, 2013 at 20:46
  • Warning from a security non-expert: Even encrypted data on the client side is at risk of being stolen. It's actually arguably easier to steal confidential data on the client's machine than data going over the wire.
    – Jeffrey Sweeney
    Feb 24, 2016 at 17:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.