HTML5 local storage: 5mb limit, not real DB
SQL Lite: no DB limit, MySQL Lite DB, integrated with PhoneGap (from PhoneGap I can manage all storage created and managed using Sencha Touch 2)
webssql: ??
There are some annoying issue which i'm facing and i'm still looking into. But for now i have almost done read and create section. I will update github once it is completed
In the previous Sqliteproxy, when u loaded a store with custom sql, (which contains custom fields that were not in the model of the store) the store loaded with the custom fields at the end. Now with the new version, only the fields in the model are loaded.
This was a useful feature before, is possible to recover it in this version?
sqliteproxy work well with Chrom but when I make deploy sqliteproxy to android machine with phonegap, it faield. There is a javascript TypeError exception in every [me.config.dbConfig.dbConn.transaction] in SqliteProxy.js.
So i have to add these line to construct of SqliteProxy to init dbConn again. I do not know why but it worked -> please review this solution for me. Thanks
//ensures that the reader has been instantiated properly
this.setReader(this.reader);
var me = this;
me.config.dbConfig.dbConn = openDatabase(me.config.dbConfig.dbName,
me.config.dbConfig.dbVersion,
me.config.dbConfig.dbDescription,
me.config.dbConfig.dbSize);
me.createTable();
},