SQLite and HTML5 for an Offline/Online application

Question

0.00/5 (No votes)

See more:

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.

Posted 6-Sep-11 10:24am

Nunnenkamp

Updated 7-Sep-11 5:48am

v3

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2011-09-06T11:12:00

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 and HTML5 for an Offline/Online application

1 solution

Solution 1

Add your solution here

Preview 0

SQLite and HTML5 for an Offline/Online application

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us