postgres-memory-server

Spin up a real, disposable PostgreSQL or ParadeDB instance programmatically from Node.js (v20+) for testing — no Docker required. Version 0.2.2 uses embedded-postgres to bundle PostgreSQL binaries (~10MB) and auto-downloads pg_search and pgvector extensions from official releases. Unlike ephemeral Docker containers, this library avoids daemon dependency, supports snapshot/restore via template databases, and caches extension binaries in ~/.cache. It is inspired by mongodb-memory-server / redisjson-memory-server but tailored for Postgres extension-heavy workloads. Release cadence is active and frequent as of early 2025. Key differentiators: no system Postgres, no Docker, ParadeDB + pgvector support, zero-copy test isolation, cross-platform binaries (macOS arm64/x64, Linux arm64/x64, Windows x64 with limitations).