Android SQLite database and app update

Question

I have developed an android app and released version 1.0. The app contains SQLite local database with 5 tables.

Now we planned to release version 2.0 also update the version 1.0 users. In version 2.0 we have included extra two tables with previous 5 table, so 7 tables now.

Now my question is, The version 1.0 users all have some data in the local database, If he update to the version 2.0 the previous data will get lost? If it so. then what is the alternate method?

@thepoosh Thank you for your reply. If I didn't change the DB architecture, but updated the version with new feature. In that case? — Rajesh Rajaram
– Rajesh Rajaram, Commented Jun 3, 2013 at 6:07
try reading this answer: stackoverflow.com/a/8627242/1056359 — thepoosh
– thepoosh, Commented Jun 3, 2013 at 6:13

codebringer · Accepted Answer · 2013-06-03 06:13:18Z

26

You should put all changes in your onUpgrade method you can use this code:

@Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    String sql = "ALTER TABLE " + TABLE_SECRET + " ADD COLUMN " +
     "name_of_column_to_be_added" + " INTEGER";
    db.execSQL(sql);        
}

this adds a column in your current database. Your database will not lose data. Reminder: onUpgrade will be called when getWriteableDatabase or getReadableDatabase is executed AND the version of your database is different from your older version.

answered Jun 3, 2013 at 6:13

codebringer

4113 silver badges7 bronze badges

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

1 Comment

Rexcirus Over a year ago

Just to clarify, TABLE_SECRET is the table name.

Gunaseelan · Accepted Answer · 2013-06-03 06:13:47Z

2

Change your db version and add extra two table creation methods in your onUpgrade(SQLiteDatabase db, int oldVersion, int newVesion) method. Now the the previous data will not get lost.

I hope this will help you.

answered Jun 3, 2013 at 6:13

Gunaseelan

15.7k12 gold badges86 silver badges130 bronze badges

Comments

Crossle Song · Accepted Answer · 2013-06-03 06:07:06Z

1

You can do some on SQLiteOpenHelper#onUpgrade, get some old data. and insert into new table

answered Jun 3, 2013 at 6:07

Crossle Song

10.2k2 gold badges31 silver badges38 bronze badges

Collectives™ on Stack Overflow

Android SQLite database and app update

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related