{"library":"postgres-memory-server","type":"library","category":null,"description":"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).","language":"javascript","status":"active","version":"0.2.2","tags":["javascript","postgres","postgresql","embedded-postgres","testing","integration-testing","paradedb","pgvector","database"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install postgres-memory-server","imports":["import { PostgresMemoryServer } from 'postgres-memory-server'","const db = await PostgresMemoryServer.create()","import { Client } from 'pg'"]},{"cmd":"yarn add postgres-memory-server","imports":[]},{"cmd":"pnpm add postgres-memory-server","imports":[]}],"homepage":"https://github.com/amanthegreatone/postgres-memory-server#readme","github":"https://github.com/amanthegreatone/postgres-memory-server","docs":null,"changelog":null,"pypi":null,"npm":"postgres-memory-server","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}