2024-02-22 PostgreSQL playground by Anton Zhiyanov

• https://github.com/electric-sql/pglite (Lightweight Postgres packaged as WASM into a TypeScript library for the browser, Node.js, Bun and Deno)

• https://electric-sql.com/ (The standard sync layer for local-first apps, Build reactive, realtime, local-first apps directly on Postgres)

• https://electric-sql.com/docs/intro/local-first

• https://fosstodon.org/@electric (Sync for modern apps. From the inventors of CRDTs.)

• https://codapi.org/postgres-pglite/

• https://c.im/@antonz/111980972200888279

PostgreSQL playground by Anton Zhiyanov

I’m so excited about this new PGlite runtime, that I just released an in-browser PostgreSQL playground on top of it!

Fully featured (well, almost) PostgreSQL in your browser, weighs only 12 MB.

• https://codapi.org/postgres-pglite

Simon Willison Commments

• https://simonwillison.net/2024/Feb/23/pglite/

PGlite (via) PostgreSQL compiled for WebAssembly and turned into a very neat JavaScript library.

Previous attempts at running PostgreSQL in WASM have worked by bundling a full Linux virtual machine—PGlite just bundles a compiled PostgreSQL itself, which brings the size down to an impressive 3.7MB gzipped.