That’s why we need Sweetch : to get a complete freedom from the client specific technologies to achieve offline web applications. Sweetch will allow your application to work on any system with Gears, AIR or Java runtime installed (more than 90% of the clients). Later, some other storage providers will be available : Flash, HTML5 and browsers specific features are planned.

We’ve noticed that Aptana has launched a similar project : ActiveRecordJs. That’s an interesting project, but its goals are different from ours : we’ll talk about it in a next post.

Next month, we’ll release a complete application demonstrating the capabilities of Sweetch : it’s going to show to everybody that Sweetch could have a great future.

/* Always use addOnLoad since it’s the only way to be sure
* that all sweetch features are available.


*/
dojox.sql.addOnLoad(function() {
// dojox.sql uses SQLite syntax

    dojox.sql(’CREATE TABLE IF NOT EXISTS myTable(id INTEGER PRIMARY KEY AUTOINCREMENT, label TEXT)’);
    var rows = dojox.sql(’SELECT id, label FROM myTable’);
    var r;
    while( r = rows.next() ) {
        console.info(r.id + ‘: ‘ + r.label);
    }

    var results = dojox.sql(’INSERT INTO myTable(label) VALUES(’Give me one more line ‘ + new Date()));
     console.info(’New record id ‘ + dojox.sql.lastInsertId());
});

Download

Add data, switch to offline browsing, add or delete data, close your browser, reopen it, reopen the page, enjoy…