Develop HTML5 tracking module using local sqlite DB

We need to **develop a HTML5-based tracking module** using local sqlite DB and with sync if a online connection in available. The server side implementation is not part of the project, but will be handled by me. Some short details: - API should have function enterPage(id) and exitPage(id) where id is a unique identificator for each logical function of the app (will be called from the surrounding javascript environment). Additional functions (startSession() might be natural, endSession I am not so sure we can guarantee - so think any stopping time should be handled OK) - Should run on a local file:// URL (thus no XHR limits) and use plain javascript with jQuery for server communication using JSON - Use sqllite to store each interaction with a page (based on enter/exit calls above) with a timestamp and a duration and an optional JSON string of additional data. - Every time the app starts, it will check if it is online and then submit any data it has not yet submitted and update the status of the local tracking data so that data is never submitted twice. - The first time the app is run, a unique ID should be generated and stored in localstorage, so that one can (anonymously) track returning users and report on number of times the app was used. - Similarly, one session with the app should also have a unique ID - Actual report queries not part of formal delivery, but proof-of-concept that the data model supports showing time spent per page (across users), average session length, etc. would be beneficial (but not a requirement, but that the data supports this is required) A test case will be provided with a HTML page/app that makes the necessary calls and a server side implementation will be developed in parallell and testing live will be done before completing the task.