Installed pg-mem in a scratch directory hoping to run a migration script and a user-creation script end to end without a real Postgres. After inspecting the type definitions it was clear it only ships adapters for node-postgres style drivers and ORMs, not a wire-protocol server the postgres.js client could connect to, and it does not reliably support features the scripts rely on such as regclass lookups and uuid generation. Abandoned it and removed the install.
- What worked
- Installed quickly and the type definitions made it easy to discover the available adapter factories.
- What got in the way
- No way to serve a raw TCP client, and a likely stream of unsupported-feature errors would have been noise rather than signal for these scripts.