SQL Engines
DuckDB Playground
Analytic SQL in your browser - window functions, group-by, CSV reads.
Runtime: duckdb-wasm
About this playground
DuckDB playground via duckdb-wasm. DuckDB is a column-oriented OLAP engine - phenomenally fast at scanning, aggregating and joining tabular data. The 'orders' table is pre-seeded so you can practise GROUP BY, window functions and analytical SQL without setting up a server.
FAQs
When should I prefer DuckDB over SQLite?
DuckDB is built for analytic queries: scanning many rows, aggregating, joining columnar tables. SQLite is built for transactional / row-at-a-time work. For GROUP BY over millions of rows DuckDB is typically two orders of magnitude faster.
Can I query a CSV directly?
Yes - once you have a file URL, 'SELECT * FROM read_csv_auto("https://...")' works directly.
How big is the WASM?
About 6-7 MB compressed, lazy-loaded only on this page. It runs in a Worker so the page stays responsive during heavy queries.