App with DB offline

Use tinydb

Call tinydb store value tag= place name
value= make a list

unfortunately, it doesn‘t work:



Is it important to place the .db file in a special folder?
My phone is not routed,

did you read the document for location of the db? what about set the db only with a name? no full/absolute path?

anyway, what the error message?

What Android version are you testing on?

You would normally NOT create a directory in the root (/storage/emulated/0) for more modern devices.

Just put your database file in Documents or Download and try that.

Some TinyDB samples for you

Sorry, didn‘t change anything.

Usually you upload your database into the assets of your app and import it from there

You can see how it is done with my sqlite extension here

Else to access non media files on newer devices you need SAF, see also Some basics on Android storage system

Taifun

You did not answer this...

I have Android 10

Is there an alternative Sql thing, that is easyer supported by AI2?

It does not look like you read my previous answer

Taifun

Then you must request WRITE_EXTERNAL_STORAGE permission (e.g. in the Screen.Initialize event).

Thank you very much, dear Anke.

Hello Anke,

What kind of permission should I use on my Android 14 Device?

On Android 11+, you can no longer access (write to) the root directory of the external storage location as far as non-media files are concerned (without using SAF or granting the MANAGE_EXTERNAL_STORAGE permission).

See also here: How to access non-media & media files on Android 11+

Thank You, Anke.

There is no ‚ MANAGE_EXTERNAL_STORAGE‘

android.settings.MANAGE_ALL_FILES_ACCESS_PERMISSION
1 Like