Ilya Boyandin
Ilya Boyandin is a software engineer at Foursquare, specializing in geo data visualization—particularly geographic movement, transport, and mobility. His passion is developing data analysis tools that help drive the transition to sustainable mobility.
Session
SQLRooms (https://sqlrooms.org/) is an open‑source, browser‑first analytics framework powered by DuckDB‑WASM. It bundles local SQL execution, state management, pluggable visual components, and an opt‑in AI layer. Because every query runs client‑side, sensitive data never leaves the machine, enabling privacy‑preserving AI agents that can write SQL, run it, perform multi-step data analysis and suggest visualisations. I will unpack the architecture and show working examples—like Flowmap City’s visualisation of Zürich transit flows—to illustrate how modular SQLRooms building blocks can be mixed and matched for civic‑tech and research projects.