Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    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.
    Carson Huang
    @kot09
    So I managed to run it. I just need to specify the archs in the run command as well : <cordova run -- --windows archs="x86">
    Christopher J. Brody
    @brodybits
    That ks
    Thanks for reporting this, it really needs to be documented somewhere. Maybe I will blog I sometime.
    Carson Huang
    @kot09
    @brodybits Is DELETE available on windows?
    Christopher J. Brody
    @brodybits
    Not yet
    Carson Huang
    @kot09
    OKay thanks.
    Carson Huang
    @kot09
    @brodybits Is tehre some work being done for DELETE on windows? If no, what is the issue? I would like to help out.
    Christopher J. Brody
    @brodybits
    A patch would be great. Try to run it against the spec test suite (and enable the tests for windows platform). Also close is not really implemented, which is a prerequisite to do delete correctly (and again test).
    Thanks for your interest!
    Carson Huang
    @kot09
    Is there a limit to the db file?
    Christopher J. Brody
    @brodybits
    Not for Android or iOS. If Windows imposes a limit I think it would be extremely high.
    Carson Huang
    @kot09
    Okay thanks. Also, is DROP available on Windows?