1. #1
    Sencha User
    Join Date
    Feb 2011
    Posts
    7
    Vote Rating
    0
    snithya is on a distinguished road

      0  

    Default Access Web SQL storage from sencha Application

    Access Web SQL storage from sencha Application


    Hi,

    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.

  2. #2
    Sencha Premium Member
    Join Date
    Mar 2010
    Location
    Nashville, TN
    Posts
    34
    Vote Rating
    1
    malkandari is on a distinguished road

      0  

    Default


    snithya,

    have you figured it out? I'm trying to find a solution for this too.

    Thank You,

  3. #3
    Sencha Premium Member
    Join Date
    May 2011
    Posts
    49
    Vote Rating
    0
    bdvr is on a distinguished road

      0  

    Default


    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.

  4. #4
    Touch Premium Member
    Join Date
    Aug 2008
    Posts
    84
    Vote Rating
    2
    dmillasich is on a distinguished road

      0  

    Default


    I for one would be very grateful for some example code as well.

  5. #5
    Sencha User
    Join Date
    Aug 2010
    Location
    Europa
    Posts
    216
    Vote Rating
    1
    kortovos is on a distinguished road

      0  

  6. #6
    Touch Premium Member
    Join Date
    Aug 2008
    Posts
    84
    Vote Rating
    2
    dmillasich is on a distinguished road

      0  

    Default


    @kortovos

    thank you

  7. #7
    Sencha User
    Join Date
    Sep 2013
    Location
    Ahmedabad
    Posts
    10
    Vote Rating
    0
    mitesh1818 is on a distinguished road

      0  

    Default


    hello friends..

    what is difference between Websql and Sqlite data base..??

Similar Threads

  1. sencha touch application for the iphone / android application store
    By wpichler in forum Sencha Touch 1.x: Discussion
    Replies: 1
    Last Post: 31 Aug 2010, 6:17 AM
  2. How to load grid store json from file in Application Storage Directory
    By stephan.raabe in forum Ext.air for Adobe AIR
    Replies: 1
    Last Post: 24 Dec 2008, 9:54 AM
  3. Scalable Application Backend Storage
    By mjack003 in forum Community Discussion
    Replies: 12
    Last Post: 2 Dec 2008, 1:48 AM
  4. ExtJS - File / Media Storage Application
    By Toes in forum Community Discussion
    Replies: 3
    Last Post: 25 May 2008, 7:26 PM
  5. Replies: 23
    Last Post: 27 Oct 2007, 3:13 AM

Thread Participants: 5

Tags for this Thread