Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    lyric123123
    @lyric123123
    then
    blob
    The same error, add the jar is not effective.
    Christopher J. Brody
    @brodybits
    You have to remove sqlite-native-driver.jar
    and make sure you install the native libraries in your libs directory instead
    lyric123123
    @lyric123123
    How to install the native libraries in my libs directory.
    Christopher J. Brody
    @brodybits
    You have to do jar xf sqlite-native-driver.jar to extract it.
    You will get a lib directory
    You have to move all the subdirectories from the lib directory into your libs directory
    I need to fix this very soon!
    lyric123123
    @lyric123123
    OK, thanks.
    shizhidi
    @shizhidi
    i want to know, where is the *.db file,I see no file on your mobile phone.
    Who knows?
    my phone
    Chun-Sheng, Li
    @peter279k
    Hi.If you use adt-bundle ,and you can open the DDMS.
    then open the file explorer and choose following path data/data/com.example.name.your-app-name/databases/your-db-name.db
    Christopher J. Brody
    @brodybits
    Thanks @peter279k. Yes for Android, external applications cannot see your database file unless you root your device (which I do not recommend). This should be documented, when I get a chance.
    Roman Chukhan
    @karatsuba
    Hi everyone! I am trying to make foreign key in table, but it does not work. Are you include such functionality in your plugin? Maybe you have some examples? Thanks.
    Christopher J. Brody
    @brodybits
    Roman Chukhan
    @karatsuba
    Thanks for link!
    Now I have next error: "FOREIGN KEY constraint failed", code "6"
    I am trying do it on iPad. Can you help me with it?
    Christopher J. Brody
    @brodybits
    laoyao
    @laoyao
    @brodybits Is there any tool to open the encryptped sqlite file?
    I am using the Cordova-sqlcipher-adapter plugin encrypt the sqlite file
    Christopher J. Brody
    @brodybits
    The sqlcipher project itself includes a CLI tool that can be used to open your encrypted database file and execute some queries. Works just like the sqlite CLI tool.
    laoyao
    @laoyao
    how to check SQLite file if is encrypted?@brodybits
    Christopher J. Brody
    @brodybits
    Check whether the SQLite file has the standard header or not. For reference: https://www.zetetic.net/sqlcipher/design/
    laoyao
    @laoyao
    I am using sqlcipher version. When I execute create index sql, the plugin report success, but acturally there isn’t a index in the sqlite db. Is there any problem?
    @brodybits
    Christopher J. Brody
    @brodybits
    Can you explain how you create the index and how you look for the index?
    lasselaakkonen
    @lasselaakkonen

    I've been using an old version of "Cordova-SQLitePlugin" from "brodysoft" github account. Now I wanted to update my plugins and it was slightly confusing to try figure out where the plugin I had used had gone and is the litehelpers plugin the same one as the brodysoft one was.

    I even found a github issue litehelpers/Cordova-sqlite-storage#95 discussing this.

    Even though https://github.com/brodysoft/Cordova-SQLitePlugin redirects to https://github.com/litehelpers/Cordova-sqlite-storage it would be nice if the Cordova-sqlite-storage readme mentioned all the old repositories which have been deprecated, so that it would be more clear/explicit what the history of the plugin actually is.

    I assume litehelpers/Cordova-sqlite-storage is a newer version of brodysoft/Cordova-SQLitePlugin? Even though I've been using version 1.0.3 of Cordova-SQLitePlugin and Cordova-sqlite-storage seems to be now v0.7.11.

    laoyao
    @laoyao
    Is it possible to upgrade the sqlcipher’s sqlite version to the latest version(3.9.2)?
    Christopher J. Brody
    @brodybits
    I just filed sqlcipher/sqlcipher#145
    nodecraic
    @webworkio
    hey, if anyone has any remote remote , designer, DevOps or Sysadmin jobs they can post them at http://webwork.io
    Christopher J. Brody
    @brodybits
    One more spam and I will delete this room!
    jigarsangoi
    @jigarsangoi
    Hello
    sourcer18
    @sourcer18
    Hello!!!! , I need a tutorial with crud sqlite in XDK, could you give me a link intel?
    thanks!
    help!!!
    It is known this error?
    blob
    Intel XDK use and storage sqlite, but I fail to display data, any ideas?
    ikhsanputra07
    @ikhsanputra07
    hey everyone i have question about cordova-sqlite, does cordova-sqlite sync to potsgresql???
    john5037
    @john5037
    Hi
    Does anybody try to use Sqlite for windows phone 8.1
    Christopher J. Brody
    @brodybits
    Answered in litehelpers/Cordova-sqlite-help#15 (this is already documented)
    asifetisalat
    @asifetisalat
    Hi..
    Please let me know if it is possible to test phoneGap application on IOS using Appium?
    Maksim
    @arimanov
    Hi! I would like to use exist database in my android project. But i can't include db file, this function window.sqlitePlugin.openDatabase({name: 'test.db', location: 'default'}); create new database only. How i can do it? Thx!
    Javier
    @jlegido
    Long time ago since last time I tested, but I used this sentence in order to open a pre-populated database:
    window.sqlitePlugin.openDatabase({name:location.db, location: 'default', androidDatabaseImplementation: 2});
    Rajesh P R
    @rajeshi2i
    Hi! what is the maximum storage limit of sqlite DB ?
    Arunprasath
    @csearun
    Sqlite Bulk insert datatable in C# ?