Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Recommended Development tools to interface with SQL Serv
Message
 
 
To
29/04/2014 09:06:31
General information
Forum:
Android
Category:
Other
Miscellaneous
Thread ID:
01599068
Message ID:
01599224
Views:
32
>>>>>>>>>>>If you can enforce an HTML5 requirement that shouldn't be a problem. With local storage and offline manifests you can easily create a web page that will work perfectly whilst offline and update when there's a connection available.
>>>>>>>>>>
>>>>>>>>>>Thanks I'll investigate that. Any suggestions on where to start learning? Same suggestion as Michael so same response :)
>>>>>>>>>
>>>>>>>>>For offline pages :
>>>>>>>>>http://www.html5rocks.com/en/tutorials/appcache/beginner/
>>>>>>>>>or
>>>>>>>>>http://diveintohtml5.info/offline.html
>>>>>>>>>
>>>>>>>>>For local storage:
>>>>>>>>>http://diveintohtml5.info/storage.html
>>>>>>>>>
>>>>>>>>>or, for the full nitty-gritty look at the w3c documentation....
>>>>>>>>
>>>>>>>>Thanks!
>>>>>>>
>>>>>>>Hi Frank
>>>>>>>
>>>>>>>I juts produced a similar system for a logistics company with signature capture etc One thing you should look out for is some windows phones use an embedded internet explorer that doesn't support some html 5 elements, particularly the canvas element. As the people where tied to the (rubbish) phones by contract we had to use a product called zetakey as their browser which works ok but there is a license cost. Having said that developing in html with local storage was a lot easier than trying to produce a seperate app.
>>>>>>>
>>>>>>>Nick
>>>>>>
>>>>>>Do you have any specific suggestions as to what "html with local storage" approach you used? I am testing a web application (that is almost finished) but I see that some customers will ask for an off-line use. So I need to start learning and maybe incorporating into my pages already. TIA.
>>>>>
>>>>>Hi Dimitry
>>>>>
>>>>>I used webSQL which worked very nicely. Its is deprecated http://programmers.stackexchange.com/questions/220254/why-is-web-sql-database-deprecated but because I knew what browser would be used that wasn't an issue as it was supported. If I re do the mobile web app to be publicly available I may alter to something else.
>>>>>
>>>>>Here's a websql example.
>>>>>
>>>>>http://www.html5rocks.com/en/tutorials/webdatabase/todo/
>>>>>
>>>>>I used it to store logistics data when the driver was offline and then he could sync it up to a sqlexpress database later. Works very well.
>>>>
>>>>Thank you for your reply, Nick. This is all new to me so I will see (study) how applicable it is for my app. Right now I can even imagine how to do it without some kind of a "light" version of DB engine on a tablet device (maybe this is what webSQL is). Anyway, I will read the references your suggested and maybe I will see the light.
>>>
>>>I was a bit puzzled where the data ended. In chrome the data is stored at : chrome://settings/cookies/.
>>
>>Thank you. In my application the process takes place in the Store Procedure so the web application collects the data and then calls a SQL Stored Procedure. So, I suppose, the "collected data" would have to "sit" in the "//settings/cookies" until the internet connection is restored. But how/what will get the data from the "hiding place" and resubmit to the stored procedure is a mystery (so far).
>
>In my case the drivers have a separate page to go to when they have signal which shows them a list of whats in the web storge db. Then they can submit that data and its deleted from the web storage as the data is loaded.
>It could be automatic but its a handy review for the drivers of what they have done or think they have done

Clearly you are already "flying" :) and I am just learning to "walk" :). Another steep learning curve. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform