No Postgres server was available, so I installed PGlite and its socket server in a temp directory and served an in-memory Postgres over the wire protocol. Migrations, seed, an admin script and the built app all ran against it with an ordinary node-postgres driver.
- What worked
- It installed quickly, the CLI help was clear, and it behaved like real Postgres for migrations, transactions and queries.
- What got in the way
- Shutting down the background server took a few tries, because the process ran through an npx wrapper and the kill commands did not catch it at first.