Posts In "HTML 5"

Sticky Notes Using ExtJS Window and HTML5 Web SQL Database

September 30th, 2010 by aditia rahman / 4 Comments  

     

In this post I want to share how to creating very simple sticky notes application using HTML 5 Web SQL Database and ExtJS Windows, this post is continuation from my previous post about creating dynamic window in extjs, since this post using HTML 5 Web SQL Database, this code for now only working on Google Chrome, Apple Safari and Opera. The feature that I will create in this post are basic insert, update, delete feature.

All the sql operation written in javascript code, first initializing database

var db = openDatabase('mydb', '1.0', 'my first database',
            2 * 1024 * 1024);

db.transaction(function (tx) {
    tx.executeSql('CREATE TABLE IF NOT EXISTS ' +
      'notes (id INTEGER PRIMARY KEY, notes text, '+
      'x INTERGER, y INTEGER)');
});