Android Question [SOLVED] Install a sqlite db so that it can be examined with sqlite browser

[RKM904]

I am testing a b4a application that deploys a sqllite database.

Currently the db (which is in the files tab) is copied from within the starter module to File.Dirinternal.

The installation and testing to date have all worked as expected. As part of testing, I would like to be able to examine the database contents as they change with data input.

Is there any location on my mobile device (Samsung Galaxy A10e) where I can install the database so that I can examine the data base contents with sqllite browser.

My searches of b4X and google all seem to indicate that if the phone is not rooted (and mine is not - nor do I want to root it) all file locations are inaccessible to any app other than the one which installed the db. Is this correct?

Any advice would be much appreciated.

thanks,
RKM

 

[Erel]

The secondary storage is accessible to other apps that hold the external storage permission.
Save the file in RuntimePermissions.GetSafeDirDefaultExternal.
You can find the path with:

Log(rp.GetSafeDirDefaultExternal(""))

You can use B4A-Bridge - File Explorer from the IDE to access the secondary storage files.

 

[RKM904]

Erel, Thank you very much for your prompt reply - this will help tremendously in my testing efforts.
I've marked the question as SOLVED

Regards,
Robert