Sweetch Blog

Sweetch now has its own wiki. Please visit it on http://sweetch.eutech-ssii.com/wiki/doku.php?id=en:start.

Since Gmail Offline release, Sweetch project has become more relevant than ever. Because, even if Gmail Offline is really a killer-app, it forces users to have the Gears plugin installed. And everybody knows that Gears is not the web : it’s not based on any standard and it’s not widely plugged in clients browsers.

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.

Sweetch 0.0.1-alpha has been released. It’s an “alpha preview” release to allow people to play with the project. You’ll find sample code below.

/* 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

A demo of Sweetch is available here. Supported providers are AIR (AIR package should be available soon), Java and Gears. It should run on several browsers (IE, Firefox, Safari, Opera, …). Give us your feedback!

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

This blog will keep you aware of all Sweetch news…