用于离线/在线应用程序的SQLite和HTML5 [英] SQLite and HTML5 for an Offline/Online application

问题描述

我正在构建时间表应用程序的计划阶段.我的公司需要一个基于Web的应用程序，但是我们有几名现场服务工程师，他们在非常偏远的地区工作且没有Internet连接.将使用Sqlite的具有脱机功能的HTML5构建应用程序是一个明智的解决方案，当检测到连接时我可以同​​步数据，或者独立的脱机应用程序会更好吗?我只是在这里寻找想法，意见或其他解决方案.


/edit-由于离线的Web应用程序功能，我正在考虑使用HTML.我们所有的数据库都是SQL Server2008.最终，我们将需要对应用程序的移动访问.我想使多平台尽可能简单，但是我不确定在当前支持它的少数浏览器中是否会继续支持SQLite.

解决方案

无法评论HTML5部分，但对数据库有一些想法:您在办公室使用哪个数据库?例如，如果它是SQL Server，并且客户端都是Windows，则使用 Sql Server Compact Edition [^ ].例如，如果要在连接后使用它来同步数据，则复制将更容易设置.

I''m in the planning stages of building a time sheet application. My company wants a web based application, but we have several field service engineers that work in very remote areas with no internet connection. Would building the app in HTML5 with offline capabilities utilizing Sqlite be a wise solution, where I could sync the data when a connection is detected, or would a standalone offline app be better? I''m just looking for thoughts, opinions or other solutions here.


/edit - I was considering HTML because of the offline web app capabilities. All of our databases are SQL server 2008. Eventually we are going to want mobile access to the application. I want to make multi-platform as simple as possible, but I''m not sure if there is going to be continued support for SQLite with the few browsers that currently support it.

解决方案

Cannot comment on the HTML5 portion but some thoughts about the database: What database you use at the office? If it''s for example SQL Server and the clients are all windows, it could be easier to use Sql Server Compact Edition[^]. For example a replication would be more easy to set up if you want to use that for synchronizing the data when connected.

这篇关于用于离线/在线应用程序的SQLite和HTML5的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！