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)');
});





