Click here to Skip to main content
13,087,235 members (60,091 online)
Rate this:
Please Sign up or sign in to vote.
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
Updated 7-Sep-11 5:48am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web02 | 2.8.170813.1 | Last Updated 7 Sep 2011
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100