Android SQLite: Fast insert/update

Question

In my Android application I am using compiled statements to be able to insert rows quickly:

insert = db.compileStatement(
                    "INSERT INTO foo (id, aaa, bbb, ccc) " +
                    "VALUES (?,?,?,?)");

This works correctly and quite fast. However when there is already foo with id, I am receiving following exception:

column id is not unique (code 19)

What would be a correct way for overwriting existing row?

If you want to overwrite it, use the UPDATE-statement.

Edwin Lambregts
– Edwin Lambregts

2015-06-22 15:08:48 +00:00
Commented Jun 22, 2015 at 15:08 — Edwin Lambregts
– Edwin Lambregts, Commented Jun 22, 2015 at 15:08

laalto · Accepted Answer · 2015-06-22 15:09:28Z

5

What would be a correct way for overwriting existing row?

Specify a conflict resolution strategy, such as

INSERT OR REPLACE INTO foo ...

If the insert would result in a conflict, the conflicting row(s) are first deleted and then the new row is inserted.

answered Jun 22, 2015 at 15:09

laalto

153k68 gold badges293 silver badges306 bronze badges

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

1 Comment

dvsoukup Over a year ago

This would work, but just be careful with it! Make absolutely sure it's what you need for your requirements. Remember, this "deletes" the row first if it exists then replaces it with the new row. This is NOT the same as a row update. If you're needing to actually update the row but not remove it, then you can first do a simple query against the table to determine if it exists, then perform an update if it does, otherwise do an insert.

Collectives™ on Stack Overflow

Android SQLite: Fast insert/update

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related