1. #1
    Sencha Premium Member
    Join Date
    Sep 2009
    Posts
    35
    Vote Rating
    5
    Aldri is on a distinguished road

      1  

    Default ST 2.2 beta 2 new SQLite Plugin

    ST 2.2 beta 2 new SQLite Plugin


    Hello !
    As seen in the changelog : "Added Native SQLite plugin".
    Is there any doc available ? Any example on how to implement this ?
    Is this also available for web apps, or only for "native" packages ?

  2. #2
    Sencha - Senior Forum Manager mitchellsimoens's Avatar
    Join Date
    Mar 2007
    Location
    Gainesville, FL
    Posts
    36,754
    Vote Rating
    827
    mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute mitchellsimoens has a reputation beyond repute

      0  

    Default


    There is no documentation yet for this or examples. Right now you would have to rely on reading the code.
    Mitchell Simoens @SenchaMitch
    Sencha Inc, Senior Forum Manager
    ________________
    Check out my GitHub, lots of nice things for Ext JS 4 and Sencha Touch 2
    https://github.com/mitchellsimoens

    Think my support is good? Get more personalized support via a support subscription. https://www.sencha.com/store/

    Need more help with your app? Hire Sencha Services services@sencha.com

    Want to learn Sencha Touch 2? Check out Sencha Touch in Action that is in print!

    When posting code, please use BBCode's CODE tags.

  3. #3
    Sencha User
    Join Date
    Dec 2012
    Posts
    10
    Vote Rating
    0
    afromogli is on a distinguished road

      0  

    Default


    Does anyone know how the SQLite-database is stored on the device? Is it stored in the browser cache or in the native file system?

  4. #4
    Sencha Premium Member
    Join Date
    Sep 2009
    Posts
    35
    Vote Rating
    5
    Aldri is on a distinguished road

      2  

    Default


    The same as the local storage, in the browser's cache (and yes, iOS 6 can wipe it without telling you)

  5. #5
    Sencha User
    Join Date
    Dec 2012
    Posts
    10
    Vote Rating
    0
    afromogli is on a distinguished road

      0  

    Default


    Quote Originally Posted by Aldri View Post
    The same as the local storage, in the browser's cache (and yes, iOS 6 can wipe it without telling you)
    Thanks for the answer! This is sad news, then I guess there is still no possibility to save files using Sencha Touch on the device native filesystem then? I was hoping it saved it on the filesystem since this was a "Native SQLite" plugin.

  6. #6
    Sencha Premium Member
    Join Date
    Sep 2009
    Posts
    35
    Vote Rating
    5
    Aldri is on a distinguished road

      1  

    Default


    Ah, maybe then. This plugin seems to be for sencha wrapper (to generate native apps, such as apk for android). It may be some sort of bridge plugin to allow writing sqlite files on the devices instead of the browser cache. I know that phonegap uses some kind of trick like this.

    My previous answer was about web sqlite in general, not about this "native sqlite" plugin which I haven't used yet.

  7. #7
    Sencha User
    Join Date
    Dec 2012
    Posts
    10
    Vote Rating
    0
    afromogli is on a distinguished road

      0  

    Default


    Quote Originally Posted by Aldri View Post
    Ah, maybe then. This plugin seems to be for sencha wrapper (to generate native apps, such as apk for android). It may be some sort of bridge plugin to allow writing sqlite files on the devices instead of the browser cache. I know that phonegap uses some kind of trick like this.

    My previous answer was about web sqlite in general, not about this "native sqlite" plugin which I haven't used yet.
    Thanks for the clarification! I see, then perhaps someone from Sencha can answer on if the Native SQLLite plugin saves data on the device native filesystem or not like for instance phonegap does. This would be a game-changer for an planned app where we have to use PhoneGap because of the need for access for native filesystem.

  8. #8
    Sencha User
    Join Date
    Dec 2012
    Posts
    10
    Vote Rating
    0
    afromogli is on a distinguished road

      0  

    Default Done some investigation

    Done some investigation


    Since I did not recieve any answers on wether or not the Native SQLLite plugin stores data on the devices native filesystem or not I ran a little test using the command line in Chrome dev tools.
    I just ran:
    HTML Code:
    Ext.device.SQLite.openDatabase({
        name: 'test',
        version: '1',
        displayName: 'test',
        estimatedSize: 100,
        creationCallback: function() {alert('DB created'); }
    });
    The call resulted in null which means that no DB was created. Examined the code and it turns out a request is made:

    http://localhost:3000/?command=SQLite%23openDatabase&sync=true&name=test&version=1&displayName=test&estimatedSize=100& creationCallback=11&__source=http%3A%2F%2Flocalhost%2Ftest%2F&_dc=1365078199504

    And since I have no server-configuration that can handle SQLite commands of course the operation would fail. Now the question is how to test-run the new native SQLLite plugin locally when running Chrome Dev Tools on a computer.. Any ideas?

  9. #9
    Sencha Premium Member vadimv's Avatar
    Join Date
    Sep 2010
    Location
    Chisinau, Moldova
    Posts
    642
    Vote Rating
    25
    vadimv will become famous soon enough vadimv will become famous soon enough

      0  

    Default


    if you can't read the code then a quick noob test is to just add some console.logs in the required place, package the app for iOS, and use Safari>Develop>your_iOS_app to look in console for logs.

Turkiyenin en sevilen filmlerinin yer aldigi xnxx internet sitemiz olan ve porn sex tarzi bir site olan mobil porno izle sitemiz gercekten dillere destan bir durumda herkesin sevdigi bir site olarak tarihe gececege benziyor. Sitenin en belirgin ozelliklerinden birisi de Turkiyede gercekten kaliteli ve muntazam, duzenli porno izle siteleri olmamasidir. Bu yuzden iste. Ayrica en net goruntu kalitesine sahip adresinde yayinlanmaktadir. Mesela diğer sitelerimizden bahsedecek olursak, en iyi hd porno video arşivine sahip bir siteyiz. "The Best anal porn videos and slut anus, big asses movies set..."