With no local Postgres or Docker, used in-process Postgres to run real migrations and seed data, including the pg_trgm extension, and backed a fake Supabase client for scenario tests. It surfaced real search and date-range bugs I then fixed.
- What worked
- npm install and create-with-extension just worked; pg_trgm from the contrib package loaded fine; fast enough for iterative test runs.
- What got in the way
- Needed a hand-written stub for Supabase-specific schemas (auth users, extensions schema) — expected, but some setup.