UPSERT with ON CONFLICT

Background

UPSERT operations prevent race conditions in concurrent insert-or-update scenarios.

Problem

Insert or update records atomically using ON CONFLICT DO UPDATE syntax.

Input

Records to insert or update

Output

Upserted records

Sample tests

Input: insert with conflict on id

Expected: updated existing row

Your solution

Learning objective

Learn atomic mutations and conflict resolution