离线访问 - SQLite或索引数据库？ [英] Offline access - SQLite or Indexed DB?

问题描述

我正处于开发应用程序的R& D阶段，具有以下关键要求：

I am in the R&D phase of developing an application, with the following key requirements:

• HTML5 网络应用程序 - 也将有混合版本


• 将存储表格数据本地，没有互联网连接

• HTML5 web application - which will also have a hybrid version
• Forms data will be stored locally, when no Internet connection

由于配额限制，我无法使用网络存储 - 我正在比较 SQLite 和索引数据库。

I cannot use web storage due to quota limitations - I am comparing SQLite and Indexed DB.

• SQLite似乎最适合，但已被弃用


• 已编入索引数据库是一个很好的选择，但没有 Safari 支持 - 混合应用程序应该将来可以在iPad和Android设备上运行。

• SQLite seems to be best fit, but it is deprecated
• Indexed DB is a good alternative, but there's no Safari support - A hybrid application is supposed to be run on the iPad and on an Android device in the future.

我很困惑选择API。在Safari上是否还有其他SQLite替代方案或索引数据库支持？

I am confused in the selection of API. Is there some other alternative to SQLite or support of Indexed DB expected on Safari?

推荐答案

我认为放弃IndexedDB会是一个坏主意，因为它可能是未来的格式，所以Safari可能会停止支持WebSQL。

I think abandoning IndexedDB would be a bad idea, because it's probably the format of the future, so Safari might stop supporting WebSQL.

看来有各种各样的JavaScript解决方案来弥合两者之间的差距 - 以两者为准可在用户的浏览器上找到：
用于桥接IndexedDB和WebSQL的JavaScript库
我认为这可能是您最好的解决方案。

It appears there are various JavaScript solutions to bridge the gap between the two - saving in whichever is available on the user's browser: JavaScript Library to Bridge IndexedDB and WebSQL I think this is probably your best solution.

这篇关于离线访问 - SQLite或索引数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！