I'm trying to make backup system in my app.
Is it possible that dynamically reload store from sqlite database ?
My app is sencha touch(1.1.1) with phonegap(1.5).

My condition is...

1: copy websql file to another directory as "buckup.db".
2: save new record to the store. and new one is in the list.
3: copy "buckup.db" to original place back (with original name).
4: store.load(); and refresh list.
5: new one still in the list.
6: I quit app. and restart. new one disappear correctly.

Re

Hey this should work perfectly with offline storage. I did this in multiple apps.
What I do is trying to load data from external and save this data into the database. Next time I try to load data from external I can load the "cached" data if the request fails.

I tried to build your sqlitedemo in phonegap for android but it did not work well. is there anything i'm missing?
here's the error:
E/Web Console(537): Uncaught Error: [Ext.Loader] Failed loading 'app/util/InitSQLite.js', please verify that the file exists at file:///android_asset/www/sdk/sencha-touch-all.js:8010