Pgmock: In-memory Postgres for unit/E2E tests

pgmock is a feature-complete, in-memory PostgreSQL database for JS/TS. It emulates an embeddable Linux VM in WebAssembly and supports existing Postgres clients out-of-the-box.

It is built upon the work by Supabase and Snaplet [1]. Compared to those, it also emulates the network stack, and hence doesn't require an external network proxy. You can create and destroy it like any JavaScript object.

It differs from the amazing pglite [2] by the technical approach. pglite compiles a Postgres fork to native WASM directly, and is hence much faster and lightweight. However, it only supports single-user mode and a select few extensions, so you can't connect to it with normal Postgres clients.

Theoretically, it could be modified to run any Docker image in WebAssembly, including other databases. Anything specific you'd like to see?

[1] https://supabase.com/blog/postgres-wasm

[2] https://github.com/electric-sql/pglite