Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to update table schema after an app upgrade on Android?

I have an unfinished application, but I want to address now the future update of it.

Suppose my app was upgraded, so when starts, detects that the database schema is outdated. So for each table has to update according to version number to the new schema while preserving all data.

I've read somewhere that on Android the SQLite database have some version number, and auto update stuff, but I didn't found an example for this specific issue.

How can this be accomplished on an Android app, using SQLite databases?

Is there a specific version number per table stored on Android SQLite databases? If so, how can I read it, and use for my above purpose?

like image 498
Pentium10 Avatar asked Feb 09 '10 20:02

Pentium10


People also ask

What is Android SQLite database?

SQLite Database is an open-source database provided in Android which is used to store data inside the user's device in the form of a Text file. We can perform so many operations on this data such as adding new data, updating, reading, and deleting this data.


1 Answers

SQLiteOpenHelper is your friend here.

You need to supply onCreate and onUpgrade methods.

like image 180
Christopher Orr Avatar answered Sep 25 '22 23:09

Christopher Orr