SQL - MERGE / UPSERT Statement
MERGE statements solve a common data synchronization problem: you need to insert a row if it doesn’t exist, or update it if it does. The naive approach—checking existence with SELECT, then branching…
Read more →Upsert
How to Use UPSERT (ON CONFLICT) in PostgreSQL
PostgreSQL’s INSERT...ON CONFLICT syntax, commonly called UPSERT (a portmanteau of UPDATE and INSERT), solves a fundamental problem in database operations: how to insert a row if it doesn’t exist,…
How to Use UPSERT in SQLite
UPSERT is a portmanteau of ‘UPDATE’ and ‘INSERT’ that describes an atomic operation: attempt to insert a row, but if it conflicts with an existing row (based on a unique constraint), update that row…
Read more →