Offline Storage

For Offline storage you can use HTML5 Web SQL Database. It is basically the SQLLite embedded into the browser. Size of these databases can be upto 1GB(what i think, i havent triied).

You can achieve the following Implementations in it:

SELECT
INSERT
UPDATE
DELETE
JOINS
And many more

Only constarint as of now is that it works with only Webkit based browsers i.e. Google Chrome & Safari

To check if your browser supports it:

window.openDatabase != undefined

if the result is true then it is supported

For making Joins you can use this code:

var db = window.openDatabase(, <DATABASEVERSION>, <DATABASEDESCRIPTION>, 1024 * 1024);

db.transaction(function(tx) {

tx.executeSql('SELECT FROM INNER JOIN ON .Id = .Id', [], , );

}, );

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Abhishek Jain13y ago
For Offline storage you can use HTML5 Web SQL Database. It is basically the SQLLite embedded into the browser. Size of these databases can be upto 1GB(what i think, i havent triied).

You can achieve the following Implementations in it:
- SELECT
- INSERT
- UPDATE
- DELETE
- JOINS
- And many more
Only constarint as of now is that it works with only Webkit based browsers i.e. Google Chrome & Safari

To check if your browser supports it:

window.openDatabase != undefined

if the result is true then it is supported

For making Joins you can use this code:

var db = window.openDatabase(, <DATABASEVERSION>, <DATABASEDESCRIPTION>, 1024 * 1024);

db.transaction(function(tx) {
tx.executeSql('SELECT FROM INNER JOIN ON .Id = .Id', [], , );
}, );