Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    vurgun533
    @vurgun533
    nasılsın
    sex
    deneme
    @phpmypython demo
    Yang Zhou
    @yz89
    hello. I have a question. @brodybits when I just open and close the ‘db’ on the same database file repeatedly, the memory always increasing. It not really close?
    Alin Pandichi
    @apandichi
    Hello. I am wondering how would one handle database migrations with this plugin. Any suggestions? Thanks!
    Christopher J. Brody
    @brodybits
    @brodybits when I just open and close the ‘db’ on the same database file repeatedly, the memory always increasing. It not really close?
    @yz89 if you see memory increasing when you repeatedly open and close the same database file, that is a memory leak. Please report which platform(s) you see the memory leak, a test program that can reproduce the leak, and also how you were able to measure the leak.
    Christopher J. Brody
    @brodybits
    @apandichi can you be more specific about what kind of database do you want to migrate, where you want to migrate it from, etc?
    Alin Pandichi
    @apandichi
    that's not what i meant. for example, in my app version 1, i have a table with 3 columns. in app version 2, i want this same table to have 3 columns. where does the "alter table" go? i remember the websql api had a method like changeVersion
    correction: v1 - 2 columns; v2 - 3 columns
    Christopher J. Brody
    @brodybits
    This plugin does not support the versions like the WebSQL API. This is already documented in the "Other Limitations" section and this point should be made more clear.
    The suggested workaround is to add a special version table with a single record to specify your version number. Upon startup, if your app detects the version is too old, or the version table is not present, then alter the table and update the version table (or create it if not present).
    Alin Pandichi
    @apandichi
    understood. thanks for your help!
    Christopher J. Brody
    @brodybits
    no problem
    Ásgeir Úlfarsson
    @asgeiru
    I am bit lost here at the moment. I have up and running phonegap application that uses https://github.com/jbavari/cordova-plugin-video-editor to transcode video. When I add SQLite as plugin the transcoding plugin starts to crash the program because it is looking for libloader-jni.so file (part of transcode plugin in sub directory). It seems somehow after I added SQLite it does not any more look for *.so files in subdirectory. :/ Any ideas?
    Christopher J. Brody
    @brodybits
    @as
    Christopher J. Brody
    @brodybits
    @asgeiru I am suspecting there is a confusion since the sqlite plugin provides armeabi and armeabi-v7a so libs, while the cordova-plugin-video-editor only provides an armeabi-v7a library. Try removing the armeabi lib directory and see if you continue to get this problem.
    Ásgeir Úlfarsson
    @asgeiru
    ok ty, will test that
    Ásgeir Úlfarsson
    @asgeiru
    Solved it. :) Removed both arm64-v8a and armeabi directory
    You know if this can cause some issues for me on the long run?
    Ásgeir Úlfarsson
    @asgeiru
    @brodybits thank you btw.. :)
    Christopher J. Brody
    @brodybits
    @asgeiru happy to hear! I will update README.md when I get a chance.
    Ásgeir Úlfarsson
    @asgeiru
    (y)
    Christopher J. Brody
    @brodybits
    The only thing is that your app will only work on the newer ARM processor now.
    Not sure about ARM 64-bit.
    Ásgeir Úlfarsson
    @asgeiru
    ahh
    Christopher J. Brody
    @brodybits
    We know this limitation is because of the cordova-plugin-video-editor. We should file a bug on that project when we get a chance.
    Ásgeir Úlfarsson
    @asgeiru
    yeah, will do that thank you.
    that repo has not been very responsive though with issues
    will have to figure this out my self I think. :) but ty for help. Now I at least know what the issue is
    Christopher J. Brody
    @brodybits
    Right. It is still good to file an issue so it can help others. Also it would help me if you file an issue on my plugin so I don't lose track of this. I suspect this is something that should really be checked by the Cordova project itself.
    Ásgeir Úlfarsson
    @asgeiru
    I will do that in the morning. :) Thank you for the assistance.
    Christopher J. Brody
    @brodybits
    :+1:
    Ásgeir Úlfarsson
    @asgeiru
    I have added issues with both plugins. Thank you for the assistance. :smile:
    Christopher J. Brody
    @brodybits
    No problem :+1:
    Javier
    @jlegido
    Good morning everybody, first time using this chat
    Raja Dinesh
    @Dineshrajaa
    Hello Brodybits,
    Thanks for making such a awesome plugin now I am having a small question , the Cordova's plugin resource has been changed to npm so have you moved Cordova-Sqlite-Plugin to npm registry?
    Christopher J. Brody
    @brodybits
    Yes
    Raja Dinesh
    @Dineshrajaa
    ok Thank you I have found it in npm registry now :)
    Roman Chukhan
    @karatsuba
    Hi everyone! Are there some memory restriction for using this plugin? I heard something about 5 MB memory space only. Thanks.
    Christopher J. Brody
    @brodybits
    Nope
    No real memory restriction by this plugin itself.
    Roman Chukhan
    @karatsuba
    So, I can use it for store pics, blobs and other sort of data on all avaible device memory?
    Christopher J. Brody
    @brodybits
    The limit per app is determined by the device. Here is what I found for Android: http://stackoverflow.com/questions/18675557/what-is-the-maximum-amount-of-ram-an-app-can-use
    Roman Chukhan
    @karatsuba
    Thanks you a lot!
    Christopher J. Brody
    @brodybits
    And by default it does use a NDK library so your limitation would be very high. For iOS similar answer: http://www.raywenderlich.com/forums/viewtopic.php?f=2&t=11701
    Alin Pandichi
    @apandichi
    Looking at SQLitePluginTransaction.prototype.handleStatementSuccess, I see that the response.rows array is transformed into a payload object where 'rows.item(i)' is a function. This forces me into a 'for' loop when I try to transform the rows into a different kind of object. I would have liked it better to be able to do a map() on the original response.rows array. Why such a change?
    Christopher J. Brody
    @brodybits
    Needed to follow the HTML5/Web SQL API
    Alin Pandichi
    @apandichi
    i see... thanks for the clear up