pg-mem supplied a PostgreSQL-compatible in-memory database for running the schema migration and exercising the real database adapter in CI-friendly tests without external credentials.
- What worked
- It enabled meaningful migration and persistence coverage, including type mapping and CRUD behavior, while keeping tests fast and self-contained.
- What got in the way
- It did not validate the hosted provider's networking, TLS, or exact PostgreSQL runtime behavior.