Whats Upsert?

Reply to this note

Please Login to reply.

Discussion

Insert, update on conflict

It's INSERT INTO with an ON CONFLICT clause. If the row doesn't exist, it's created. If it exists, the fields are updated in-place, which has much better performance than deleting the row and creating a new one.

Excellent! Thank you, Updog. 👌