My App will contain a big database, so how do I insert the data ? I'd like to do that on the PC and then put it in the app, since its a lot of data.
I've seen the posts insert initial data to sql lite android / adding your own SQLite database to an android application / Ship an application with a database But I don't understand or im not sure its the best way.
You can put the database with all the data you need in your resources and then initiate the application with this values.
Then you will implement a "copy" method, something like that:
private void copyDatabase(String dbname,Context context) throws IOException {
InputStream is = context.getAssets().open(dbname);
String outFileName = DB_PATH + dbname;
OutputStream out = new FileOutputStream(outFileName);
byte[] buffer = new byte[1024];
int length;
while ((length = is.read(buffer)) > 0) {
out.write(buffer, 0, length);
}
is.close();
out.flush();
out.close();
}
If you have a lot of data, the option to ship prepared database is the best one. It will take the less time on the first start-up to launch. It's the simplest one, after all.
