GWT client-side HTML5 database storage (Web SQL Database)

2.5k views Asked by At

I wonder if there is an API for using Database Storage in GWT 2.x or I should use native code like this instead?

var database = openDatabase("Database Name", "Database Version"); 
database.executeSql("SELECT * FROM test", function(result1) { 
    // do something with the results 
    database.executeSql("DROP TABLE test", function(result2) { 
        // do some more stuff 
        alert("My second database query finished executing!"); 
    }); 
});  
2

There are 2 answers

0
Jason Hall On BEST ANSWER

The gwt-mobile-webkit project provides these bindings so you don't have to write them yourself. Don't let the name fool you, it'll work on a desktop browser too.

0
raghum On

gwt-mobile-webkit as of now, will not run on the latest desktop browsers, since it uses the WebSQL API that is no longer supported by the latest browsers like Firefox 4+.

I have written a small library for doing client side storage. It can work with all browsers that support localstorage-api (practically all HTML5 browsers including the smart phone browsers) and allows you to store data in object stores and databases.

You can check it out here: https://code.google.com/p/gwt-localstorage-db/