SqliteProxy

[tomalex0]

I used to work with sqlite storage for while but didn't thought to write down a separate proxy until i came across http://www.sencha.com/forum/showthre...roxy.IndexedDB by grgur . So heavily depending on his code set and help from Lisimba I tried to write down another sqliteproxy for sencha touch. This is just in initial stage.

I write down the proxy based on implementing a Demo Functionality and it works fine for it. Usecase of others will be different. So please have a look and let me know your feed back.

You can find code and demo implementation under
SqliteProxy-Github

Note : Sencha guys already planned for this.

[temolesto]

Thanks a lot, i'm just starting with Sencha and this is the first thing that i was looking into.

[tomalex0]

Nice to know that this turned out to be helpful for you. If you come across any issues please let me know

[temolesto]

how can i change the Proxy.dbConfig.dbQuery of a sqliteproxy after definition of the store or model

i want to press a button and change the criteria of the selected rows of the table, i have tried this when updating

var p = myStore.getProxy();
p.queryDB(p.dbConfig.dbConn, 'Update table set column=300;');

successfully executing the update query or select some data

function querySuccess(tx, results) {
    document.getElementById('total').innerHTML=results.rows.item(0).Num+' Total';
    }
    var p = this.store.getProxy();
    p.queryDB(p.dbConfig.dbConn, 'select count(*) as Num FROM table;',querySuccess);

but now i want to change the dbquery of the storage and i cant find how to do this

var p = this.store.getProxy();
p.dbconfig.dbQuery = 'Select * from table order by column desc Limit 30';

im just starting with sencha and js in general, thanks for your help

[tomalex0]

Can you try

this.store.load();

after setting the dbQuery

[temolesto]

thanks, my error was actually dbconfig should be dbConfig

var p = this.store.getProxy();
p.dbConfig.dbQuery = 'Select * from table order by column desc Limit 30';
this.store.load();

thanks for your help

[karthiktheraja]

Hi I am new to sencha touch and I want to use sqlite for offline data store . I want know whether there is performance difference between Phonegap sqlite and sqliteproxy.Does sqliteproxy supports iphone , android and Blackberry . Can you please tell me whether there is any memory restriction . Kindly help me to proceed further ....

[tomalex0]

@karthik

I haven't tried it in Phonegap,
Regarding support, sqlite Db is supported in all webkit based browsers. So sqlite proxy meant to work with those .
I think developement on sqlite in browser has been dropped by w3c and likely to be replaced with indexDB.
http://www.w3.org/TR/webdatabase/

By default device will use 5MB of space, if it tends to exceed it will prompt an option to increase the space.

I'm also not sure about how phonegap works with DB that we creates using html5 websql?

[karthiktheraja]

Thanks for your reply . I followed your sample and It works great . But I am not able to understand the flow of your code. I am just doing a login form validation . I need to create a login table and need to insert ,select and delete user account. In your example you have commented out select query but still i get a log for select query. Please give me a short explanation of how to work with your code. I want know how your code is working with browser sqlite as in phoneGap I used window.openDatabase("Database","1.0","PhoneGap Demo", 200000); method to open database.

[tomalex0]

Hi,
The way proxy read is done like that it takes either tablename or query. If you have specified query it will be executed else select all from tablename.
So in both case there will be a select query executed when store load in initiated.

When any action is carried out with model having sqlite proxy it will create a table with fields mentioned in model. The inner function already checks for if table already exists.

Lookout the property isTableField.

I have also made a small change in github code.