Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    Á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
    laoyao
    @laoyao
    how use this plugin?
    is there any complete api documents?
    Do I need the following :http://dev.w3.org/html5/webdatabase/?
    Is there any boy can give some advise?
    laoyao
    @laoyao
    anybody?
    laoyao
    @laoyao
    help
    Christopher J. Brody
    @brodybits
    You open a database using window.sqlitePlugin.openDatabase with parameters as described in README.md and then follow the API in the w3 webdatabase link how to perform sql transactions on the database object. This is already documented in README.md.
    One thing is that only asynchronous transactions are supported. I will add this to README.md when I get a chance.
    laoyao
    @laoyao
    thanks
    laoyao
    @laoyao
    i can not find any close db function in the w3c specification docs. Is there anybody found it?
    Christopher J. Brody
    @brodybits
    Sorry
    Sorry, close db and delete db are not part of the w3 spec.
    laoyao
    @laoyao
    @brodybits can you help me?
    Christopher J. Brody
    @brodybits
    What are you trying to do?
    laoyao
    @laoyao
    No need to close db?
    May i
    Christopher J. Brody
    @brodybits
    No problem if you do not close the db. You know sqlite is ACID compliant, which means it should NEVER lose data once it is committed.
    Carson Huang
    @kot09
    Hi, I'm trying to install the sqlite plugin on windows. I have two questions. 1) Is there a way to install the plugin after a project has been created? I'm reading the instruction to install the plugin using plugman and nufix, but the steps are for creating a new project. 2) The last step mentionned : "Put your sql program in your project www (don't forget to reference it from www\index.html and wait for deviceready event)"; what does it mean to put the sql program in the www project + referencing it?
    Christopher J. Brody
    @brodybits
    1. If your project has already been created, just install the plugin as normal: cordova add plugin github.com/litehelpers/Cordova-sqlite-storage
    Carson Huang
    @kot09
    Still using plugman, correct?
    Christopher J. Brody
    @brodybits
    How did you originally create your project: did you use the Cordova CLI or did you use plugman?
    Carson Huang
    @kot09
    I originally created the project using the Cordova CLI.
    Christopher J. Brody
    @brodybits
    Then use the Cordova CLI to add the plugin and see if it works
    Carson Huang
    @kot09
    That's what I tried before, and for Windows platform, it gives me some error, related to architecture
    On iOS, adding the plugin using CLI works perfectly. It's just for the windows platform I'm having issues.
    Christopher J. Brody
    @brodybits
    Are you using Visual Studio to run the program or are you using Cordova CLI to run the program?
    Carson Huang
    @kot09
    I tried both.
    Christopher J. Brody
    @brodybits
    explicitly. In Visual Studio, there is a drop-down for it. When using Cordova CLI, there is an option (I forget which one)
    You have to specify which CPU architecture, i.e. x86/x86_64 (or x64, I forget which)/arm
    Carson Huang
    @kot09
    In CLI, I explicitly built it with x86
    I'll try it again, give me a second.
    Carson Huang
    @kot09
    @brodybits So I just took a clean copy of my project, added my other plugins + sqlite through CLI. When I build windows, I specifically mention x86 <cordova build windows – --archs="x86">. I then run it using <cordova run -- --windows>, and it gives me the following error: The processor architecture of your project 'neutral' doesn't match the processor architecture 'x86' of the referenced project 'SQLite3'. Change the targeted processor architectures to align between your project and its references.