Facebook Twitter Gplus LinkedIn RSS
Home Local Database

Local Database

Now that you’ve got the looks and offline capability working in your app, why not take it to the next level and add a local database?  This client-side database is probably one of the most useful aspects there are when creating an offline web application.  With this local database, we can store and modify values all on the client’s side, allowing each individual device to have data of its own.  Useful creations utilizing this database include to-do lists, where a user can add, edit, or delete items in a list form, or even all out apps that allow downloading from a server, modifying data locally, and syncing back updated info back to the server.  How far you take the local database is up to you.

To use this database we will be using Javascript, a language you should already be familiar with if you are already at this step.  This local database, or web SQL, mimics that of Sqlite’s language.  In this portion of the guide, we will learn how to open a database, send queries to that database, and how to include database versioning in our app.  Remember, this is the toughest out of the three sections of this guide, but is probably the most important to understand if you want to make a thorough app!  Here are the chapters of this section.  Click on to start reading!

  1. Opening the Database
  2. Database Transactions
  3. Database Versioning

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>