should I use "query" + "update/insert" or "insert/replace" in android sqlite?

Question

I have a table like this

        db.execSQL("CREATE TABLE " + TABLE_NAME + " ("
                + _ID + " INTEGER PRIMARY KEY,"
                + URL + " TEXT UNIQUE,"
                + SomeInfo + " TEXT,"
                + OtherInfo + " INTEGER"
                + ");");

So there is only one record for each URL value. When the user visit a URL, I need neither insert a new row, or update an existing row if URL is presented I could think of 2 ways:

SQLiteDatabase.query first and apply an update if there is one
Always use SQLiteDatabase.replace, in case the UNIQUE constraint fail, sqlite will replace the record.

Which approach is better? Are there other suggestions? Thanks

Community · Accepted Answer · 2017-05-23 12:12:00Z

1

Since this seems to be a commom issue (which I faced recently too) I found this post which might be helpful.

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Sep 21, 2011 at 19:25

Knickedi

8,7873 gold badges46 silver badges45 bronze badges

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

Collectives™ on Stack Overflow

should I use "query" + "update/insert" or "insert/replace" in android sqlite?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related