PostgreSQL Upserts with INSERT ... ON CONFLICT: Atomic Insert-or-Update
Use INSERT ... ON CONFLICT to insert or update a row atomically when a unique constraint exists, and verify the result with the command tag.
Loading…
SQLite UPSERT: Making Insert-or-Update Safe Under Concurrency
Use SQLite's INSERT ... ON CONFLICT DO UPDATE to replace SELECT-then-write races with a single idempotent statement, provided a UNIQUE or PRIMARY KEY defines the conflict target.
sqlite