Create SQLite db with data

[larryse]

I am creating a Q & A app. i was thinking of storing the info in the SQLite db. I figured i would create the app with some text file to store the info and when the db was created it would read the text files and save the data in the db, then delete the text files.

1. is this possible, to delete the files
2. is this the best way to do it.

thanks

 

[v777779]

1. You can't modify files inside apk.
https://stackoverflow.com/questions...-from-the-assets-folder-at-runtime-in-android
https://stackoverflow.com/questions...eleting-a-file-in-assets-folder-automatically
But if there is some text file in the target Android device file system, yes, you can delete it.
https://stackoverflow.com/questions/5486529/delete-file-from-internal-storage

2. Database in Android Content provider
https://developer.android.com/guide/topics/providers/content-provider-basics

 

[cybernetix]

My thoughts:

1) If you have some TXT file inside your assets,
you can just leave it after copying into DB.
I guess its rather some kB's, so it does not take almost any space.


2) You are planning to write logic that does following:
- convert from text file to java
- convert from java to DataBase
- later, read from DataBase and display this text.

I see redundant work here.
You could skip database,
and just in the moment where you display it, read it from text file.

3) Also another option,
you can create / edit database file on Windows with SQLite Expert,
put some data in there,
and attach this database to your APK,
as a starter DB.