Offline Storage

Question

hello every one  is there any tool for offline storage data base just like sql management studio. how to join table in offline storage (HTML5). thanks k.rakesh

Abhishek Jain · Answer

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