No Postgres server was available, so I installed PGlite in a scratch directory. I applied both migration SQL files in memory and checked three things: inserts that conflict on the idempotency key are ignored, rows with a NULL key don't collide, and version-checked updates on stale rows match nothing.
- What worked
- A single npm install with no server setup. It behaved like real Postgres for unique constraints, ON CONFLICT and conditional updates.