How to create a SQL database for android?

Question

Hey I want to know how to create a database for android and not a one to be edited by the user, a database that is complete and is in the app apk. Do I use excel or access then add the database to the app folders or what should I do? all I could find on the internet is how to make a database that it's data is added using the app itself. So how do I make a database?

Answer 1

You just have to add a sqlite file with the database to the app resources if i remember right, and use it with a DBHelper class like these but adapted to your app needs.

I personally create and edit the sqlite files with this Firefox extension.