Click here to Skip to main content
11,803,019 members (58,948 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: SQLite HTML5
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
Edited 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
0 OriginalGriff 335
1 KrunalRohit 291
2 F-ES Sitecore 270
3 CPallini 270
4 Sergey Alexandrovich Kryukov 234
0 OriginalGriff 2,950
1 Maciej Los 1,910
2 KrunalRohit 1,862
3 CPallini 1,735
4 Richard MacCutchan 1,157

Advertise | Privacy | Mobile
Web02 | 2.8.151002.1 | Last Updated 7 Sep 2011
Copyright © CodeProject, 1999-2015
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