Building local-first analytics apps with SQLRooms
summary
Open-source SQLRooms packages a whole analytics workspace into a single-file DuckDB project that stores data plus UI and app state, donated to the OpenJS Foundation and used in Flow Map City and Foursquare tools. It supports DuckDB via WebAssembly, MotherDuck, or an embedded Python server, offers query/schema UIs, resizable panels and dashboards, and a modular artifact system. A CLI (installable with UV) creates projects and exposes Pyodide cells with a DuckDB bridge plus Mosaic dashboard and HTML-app artifacts; it is experimental.
AI-written summary · about
related talks
25mA quack of all trades: DuckDB, a versatile analytical database to keep in your toolkit
05mDuckDB Powering Interactive Notebooks
47mPlay Data Engineer Locally with DuckDB
09mIntegrating DuckDB with Fluvio
30mDuckDB: Bringing analytical SQL directly to your Python shell
40mDuckDB: Harnessing in-process analytics for data science and beyond
28mAnalyze data easily with duckdb - and the implications on data architectures
34mData Wrangling with DuckDB