Android SQLite Database update table when update app

Question

I have situation :

In the newer version of the app i will add another column to the SQLite table. I need to make this change take effect when application is updating and do not lose data from database (via recreating with new structure).

May be in onUpgrade start my SQL Update scripts? How to do it correctly?

Just use Alter Table sql command and add new column. it's not effect to your data. Do it inside onUpgrade(.....) — M D
– M D, Commented Aug 2, 2016 at 8:40
I know sql script, but can i safely do it in the onUpgrade? Which is standard solution fot this task? — Majkl
– Majkl, Commented Aug 2, 2016 at 8:41
What you expect then? This is the only one and standard way. — M D
– M D, Commented Aug 2, 2016 at 8:41

Jean-François Fabre · Accepted Answer · 2019-11-07 09:48:49Z

3

You have to upgrade your database version in onCreate() and then use onUpgrade(). Like this:

public YouSQLiteHandler(Context context) {
    super(context, Constants.DATABASE_NAME, null, Constants.DATABASE_VERSION); --> 1 to 2 for example


}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {


    addNewColumnTable();
}

When you change your database version, Android automatically call onUpgrade() and your database will be updated with all the changes that you put in onUpgrade() when the user update the app

edited Nov 7, 2019 at 9:48

Jean-François Fabre♦

141k24 gold badges179 silver badges246 bronze badges

answered Aug 2, 2016 at 8:51

Miguel Benitez

2,32212 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Android SQLite Database update table when update app

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related