title: Mobile app for web application (offline storage)
body: <p>I hope this question belongs here. I am developing a web application for a client. It involves creating appointments/quotes for tradesman and need some advice.</p>
  
  <p>Basically there are products that can be added to a quote created on the webapp. I want to be able to select the quote on the mobile app from a smartphone a fill out the quote. </p>
  
  <p>The problem I face is that because there might not always be internet connectivity I need to store quote data offline on the device so that it can be synchronised when there is internet.</p>
  
  <p>Here is the process using the mobile app:</p>
  
  <ol>
  <li>User gets appointments from web application and stores them (preferably in a database)</li>
  <li>Even with no connection user can then fill out quote on the appointment.</li>
  <li>User saves quote</li>
  <li>Mobile app automatically sends new quote to web application (if connection)</li>
  <li>When internet is available user manually synchronises data</li>
  </ol>
  
  <p>The web application takes care of creating appointments and managing the products. The mobile device stores it's own copy of the products and simply just a reference to the quote.</p>
  
  <p>So the user can see a list of appointments. Selects the appointment and then begins to add products. </p>
  
  <p><strong>appointments</strong></p>
  
  <p>appointment_id</p>
  
  <p>description</p>
  
  <p><strong>products</strong></p>
  
  <p>id</p>
  
  <p>description</p>
  
  <p><strong>quote</strong></p>
  
  <p>id</p>
  
  <p>appointment_id</p>
  
  <p>product_id</p>
  
  <p>The web application has been developed in PHP. </p>
  
  <p>I'd like to take advantage of HTML5's offline storage for the mobile app as I'm a web developer and don't have time on this project to learn a native language (i.e objective-C). I've read in a couple of places that web SQL database is not going to be continued so I'm not really sure what my options are.</p>
  
  <p>Also for code in thinking HTML5 and JavaScript, so probably using jQTouch or jQuery Moble.</p>
  
  <p>If anyone has any suggestions or recommendations for me that would be great!</p>