Where communities thrive

Join over 1.5M+ people
Join over 100K+ communities
Free without limits
Create your own community

Explore more communities

litehelpers/Cordova-sqlite-storage

A Cordova/PhoneGap plugin to open and use sqlite databases on Android/iOS/Windows Universal(8.1)/WP(7/8) with HTML5/Web SQL API

People

Repo info

Activity

lyric123123

@lyric123123

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

Check this out: http://stackoverflow.com/questions/31268269/cordova-sqlite-foreign-keys

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

Please post this question with a demo program at https://github.com/litehelpers/Cordova-sqlite-storage/issues or https://github.com/litehelpers/Cordova-sqlite-help/issues

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

David

@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?

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

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 Tsipun

@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# ?

Chrizzly

@Chris2011

Hey, I use nanosql for the DB to test it in browser witn IndexedDB and on my production phone with SQLite. Now I will switch to this plugin because it has browser support to, but I have a pre populated file which I copy over from my www folder to the database folder of the application. As I see some comments, that this is not possible and I asked myself why. I need an extra plugin called cordova-sqlite-ext to do that? Is this correct? I thought I can copy over my prepopulated file, i will open the databse with the params and it works, doesn't it?

So my question is, why do I need the cordova-sqlite-ext plugin? Maybe @brodybits can help me here :)