Cordova + SQLite plugin in a ionic app: where the DB file is saved?

[Giovanni Allegri]

I need to access the stored DB created with $cordovaSQLite.openDB({ name: "appdb.db" }), but I can't retrieve its physical location on the device.

Where can I find the default storage path? 

I'm on a Galaxy Nexus (only internal memory, with emulated sdcard).

Thanks,

Giovanni

[Giovanni Allegri]

I've modified to plugin to add a method which returns the db path. Finally I've discovered it is under /data/data/org.ionicframework.etc...., i.e. a hidden folder, which only root can get access.

What about adding the option to define where to store the DB? I will add this to my modified plugin...

Giovanni

[Chris Brody]

I am planning to add an option to change the database path, sometime in the future. Due to my ongoing business commitments I cannot make any promise when.

Thanks,

Chris

--
You received this message because you are subscribed to the Google Groups "Cordova-SQLitePlugin" group.
To unsubscribe from this group and stop receiving emails from it, send an email to Cordova-SQLitePl...@googlegroups.com.
To post to this group, send email to Cordova-SQ...@googlegroups.com.
Visit this group at http://groups.google.com/group/Cordova-SQLitePlugin.
To view this discussion on the web visit https://groups.google.com/d/msgid/Cordova-SQLitePlugin/20c13092-cfa3-4713-8d86-008321f06be6%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Sent from my mobile

[sebastia...@ajustev.com]

hi giovanni , im having the same problem, i need to check the path of db, could you share the plugin with the option to get the db path:

many thanks in advanced

[G. Allegri]

Hi Sebastian,

I've abandoned the project (I've switched to a different solution). I hope I will find the code to share it with you...

giovanni

--
You received this message because you are subscribed to a topic in the Google Groups "Cordova-SQLitePlugin" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/Cordova-SQLitePlugin/iXl0Jo3QpMA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to Cordova-SQLitePl...@googlegroups.com.

To post to this group, send email to Cordova-SQ...@googlegroups.com.
Visit this group at http://groups.google.com/group/Cordova-SQLitePlugin.

To view this discussion on the web visit https://groups.google.com/d/msgid/Cordova-SQLitePlugin/14686379-4ee1-4587-bbfe-5e2cd6d83410%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

--

Giovanni Allegri
http://about.me/giovanniallegri

Gis3W - http://gis3w.it

Ikare - http://ikare.it

Twitter: https://twitter.com/_giohappy_

blog: http://blog.spaziogis.it
GEO+ geomatica in Italia http://bit.ly/GEOplus

[Chris Brody]

Answered in #223
(https://github.com/brodysoft/Cordova-SQLitePlugin/issues/223) by
@jlegido:

this.dbLocalFileUrl = {android: '/data/data/' + this.packageName +
'/databases/' + this.dbName,
ios: 'cdvfile://localhost/persistent/' + this.dbName,
win32nt: '/' + this.dbName,

This really needs to be fixed in the documentation!

Chris

> --
> You received this message because you are subscribed to the Google Groups
> "Cordova-SQLitePlugin" group.
> To unsubscribe from this group and stop receiving emails from it, send an

[chetan....@veloziti.com]

I have found out one solution for the same is to install SqliteMaster app in your device which let you see the file structure for individual application as well as table structure.

[studi...@gmail.com]

As far as I can see from Quiz Ionic SQL App template this are the folders where a prepopulated database file is located for SQLite when opening under a browser:

Windows XP

•   Google Chrome: C:\Documents and Settings\ USERNAME \Local Settings\Application Data\Google\Chrome\User Data\Default\databases\http_localhost_8100\
•   Chromium: C:\Documents and Settings\ USERNAME \Local Settings\Application Data\Chromium\User Data\Default\databases\http_localhost_8100
 

Windows 10 / 8 / 7 / Vista

•   Google Chrome: C:\Users\ USERNAME \AppData\Local\Google\Chrome\User Data\Default\databases\http_localhost_8100\
•   Chromium: C:\Users\ USERNAME \AppData\Local\Chromium\User Data\Default\databases\http_localhost_8100\

Mac OS X

•   Google Chrome: /Library/Application Support/Google/Chrome/Default/databases/http_localhost_8100/
•   Chromium: /Library/Application/ Support/Chromium/Default/databases/http_localhost_8100

And when in device, after using DBcopy plugin to copy database file from www folder into DocumentFolder, you can use:

  var platform = $cordovaDevice.getPlatform();

         //destination folder path per platform

         if(platform == "iOS"){

           //iOS non-synch folder

           path=cordova.file.applicationStorageDirectory + "Library/LocalDatabase";

         } else {

           //Android folder

           path=cordova.file.applicationStorageDirectory + "databases";

         }

         targetPath = path + "/" + dbname; //full path to the datafile once downloaded

For additional information: http://codecanyon.net/item/quizionic-a-quiz-app-template-for-ionic-framework-with-sqlite-database/14205904

[gss...@gmail.com]

Hi,

I am still facing the issue of sqlite database not getting stored on android phone. It seems to work on ios. I using ionic hybrid app development.
 I am testing with multiple phones.


My sqlite plugin versions are as follows:

cordova-plugin-sqlite-2 1.0.4 "SQLitePlugin"
cordova-sqlite-storage 2.0.3 "Cordova sqlite storage plugin"