PGlite

PGlite is a full Postgres database compiled to WebAssembly, so it can run inside a browser or a JavaScript app. The build is small, under 3 MB gzipped, and it includes extensions such as pgvector.

PGlite gives an app a local Postgres database with live queries and data sync primitives. Extensions can be loaded dynamically, and the project lists support for pgvector and PostGIS. It is useful when you want Postgres behaviour without running a separate server.

• Full Postgres running in WebAssembly
• Build under 3 MB gzipped
• Dynamic extension loading
• Live queries and sync primitives
• pgvector and PostGIS support

JavaScript developers who build apps that need a local Postgres database, such as prototypes, demos and offline features. Frontend teams that want to try Postgres queries in the browser may also use it.

PGlite is free and dual-licensed under the Apache 2.0 licence and the PostgreSQL License. Because it is an embedded database, the data lives inside the app's own environment. Check the docs for which extensions and browser features work in the runtime you plan to target.