No local Postgres was available, so I installed PGlite in a temp directory and ran all migrations plus scenario tests in Node, stubbing the Supabase-only extensions. The first run surfaced a real queue-jumping bug, which I then fixed.
- What worked
- Installed quickly and ran real plpgsql, roles, grants and triggers in-process. Fast enough to iterate on scenario tests and permission checks.
- What got in the way
- Extensions like pgmq, pg_cron and pg_net aren't available, so I had to write stand-ins, which limits how faithful the test is.