With no Postgres in the environment, I installed PGlite into a scratch directory and applied all project migrations, then ran the outbox trigger, LISTEN/NOTIFY, SKIP LOCKED claim, fan-out and lease queries in-process. Everything ran as real Postgres would, including NOTIFY firing on commit and not on rollback.
- What worked
- Installed quickly with no native build. Supported plpgsql triggers, pg_notify, row locking syntax and positional parameters, so I could check real migration SQL with no server.
- What got in the way
- It is single-session, so it cannot show real concurrency between connections. That is expected for an embedded engine.