10 Feb 2011 10:36 PM #1
Access Web SQL storage from sencha Application
I would like to know if its possible to access and use data from Web SQL storage from the Sencha Touch Application? If yes are there any sample applications or examples.
9 May 2011 1:57 PM #2
have you figured it out? I'm trying to find a solution for this too.
9 May 2011 7:13 PM #3
I'm using WebSql in my current project, so yes it can be done. ST provides no built-in support for WebSql, so we're pretty much on our own. Perhaps they are waiting for IndexedDB, but I'm not. No native support for joins, complex where clauses, aggregate functions? No thanks!
I ended up writing some custom objects to make working with the db and creating SQL statements a bit easier. I find the concept of proxies that only do CRUD to be a bit too simplistic when I have queries with all kinds of joins, where clauses, and aggregate functions, as well as business objects with methods that do more than one operation on more than one table in a transaction. I guess proxies work well with LocalStorage for fairly trivial things, but I ended up bypassing proxies, and instead opted to have methods on my models and stores with custom ad-hoc SQL.
Maybe others have had different approaches? I'll see if I can post some example code soon.
9 May 2011 7:33 PM #4
I for one would be very grateful for some example code as well.
9 May 2011 11:11 PM #5
11 May 2011 10:37 AM #6
4 Oct 2013 3:24 AM #7
what is difference between Websql and Sqlite data base..??
By wpichler in forum Sencha Touch 1.x: DiscussionReplies: 1Last Post: 31 Aug 2010, 6:17 AM
By stephan.raabe in forum Ext.air for Adobe AIRReplies: 1Last Post: 24 Dec 2008, 9:54 AM
By mjack003 in forum Community DiscussionReplies: 12Last Post: 2 Dec 2008, 1:48 AM
By Toes in forum Community DiscussionReplies: 3Last Post: 25 May 2008, 7:26 PM
By bahar in forum Community DiscussionReplies: 23Last Post: 27 Oct 2007, 3:13 AM