Local analytics without a database server: the SQLRooms and DuckDB approach
JeremyCMorgan · x · 2026-11-19
DuckDB's blog features SQLRooms creator Ilya Boyandin on local-first analytics: running analytical queries in the browser with DuckDB-Wasm, no database server needed.
- It started with the Flowmap City side project: datasets stored as Parquet in S3, loaded into DuckDB-Wasm via presigned URLs; panning/zooming triggers SQL queries in-browser, cutting infrastructure and round trips.
- That evolved into SQLRooms, a toolkit for analytics apps combining data, visualizations, and AI-assisted analysis on the user's machine.
- Philosophy: you should own your data—cloud sync optional, local vs cloud is your call.
- Background: Boyandin also built FlowmapBlue and worked at Unfolded, the company behind deck.gl/kepler.gl later acquired by Foursquare.
More from Apps
- 24 rural Cambodian 7th graders all outscore the average US 12th grader in math — saranormous · 2026-11-19
- Shopping Simulator: A 3D Web Demo Where You Practice Buying Nothing — yungcontent · 2026-11-19
- Naïve Clipping launches as an AI long-video-to-shorts tool claiming 21x cheaper than OpusClip — nikola_mr64990 · 2026-11-19
- IconSwapper launches for Mac: a $19 icon studio that animates your Dock with live AI usage — Dimillian · 2026-11-19
- Microsoft kills To Do app, tells users to move to Planner — LuoSays · 2026-11-19
- Open-Source EggLab Brings Local Image Gen, Editing and an AI Design Agent to PhotoCraft — AdditionCorrect2929 · 2026-11-19