SQL Engines
PostgreSQL Playground
Real Postgres in your browser via PGlite - jsonb, CTEs, window functions.
Runtime: PGlite (Postgres in WebAssembly)
About this playground
Postgres playground via PGlite - the official ElectricSQL build of Postgres compiled to WebAssembly. Real Postgres parser, planner and executor: jsonb, generated columns, recursive CTEs, window functions and arrays all behave exactly as on a server. The 'students' table is pre-seeded.
FAQs
How is this different from SQLite?
Postgres has a richer type system (jsonb, arrays, intervals, custom types), stricter SQL conformance and a more capable optimiser. Worth practising on if your production database is Postgres.
How big is the WASM?
PGlite is around 3 MB compressed and is lazy-loaded only when you open this page.
Will extensions like pgvector work?
PGlite supports a subset of extensions out of the box (pgvector among them). Niche extensions that need OS-level features won't load.