←
Ilya Boyandin 🇺🇦752 posts
Ilya Boyandin 🇺🇦 avatar

Ilya Boyandin 🇺🇦

@ilyabo

ilyabo.bsky.social geo data visualization engineer at @Foursquare. creator of SQLRooms.org and Flowmap.Blue. past @teralytics @ixt @unifr

◷ Joined February 2009▧ 125 Photos and videos
Foursquare avatar
⟳ Ilya Boyandin 🇺🇦 retweeted
Foursquare@Foursquare·25 Jun 2025

Today, we're thrilled to launch SQLRooms — a modular React toolkit that enables developers to build powerful single-node data applications running entirely in browsers or on desktop, with zero backend infrastructure required. While modern analytics frameworks still depend on hub-and-spoke architectures with heavy server-side processing, recent breakthroughs in single-node computing have fundamentally changed what's possible. 💡 We asked ourselves: what if data applications were architected for single-node performance from day one? SQLRooms, architected by @ilyabo, is our answer. By integrating @duckdb as the core compute engine, embedding AI assistance through @ollama, and providing a comprehensive component library, SQLRooms empowers developers to create enterprise-grade applications that run directly where where users need them — in browsers and on laptops. Key highlights 👇 → DuckDB-WASM at the core: Lightning-fast columnar SQL processing in-browser. → Modular & developer-centric: Mix and match UI components, layouts, SQL engines, data tables, editors, and visualizations. → Interactive SQL + visual analytics: Built-in SQL editor with syntax highlighting, query history, and seamless visualization library integrations. → AI-native analytics: Integrated agents that write and execute SQL queries, generating insights locally – no server roundtrips required. We believe single-node computing will unlock a new category of applications, especially as data privacy concerns grow and the proliferation of powerful edge models makes local processing the new standard. ✨ SQLRooms is our contribution to making that future accessible today. Ready to explore browser-native analytics? Read the full launch blog post by our CTO, @vikramgundeti, below and check out the SQLRooms homepage in the thread to get started with building your first single-node data application 👇 medium.com/@foursquare/fours… #SQLRooms #DataApps

Post attachment
Jeffrey Heer avatar
⟳ Ilya Boyandin 🇺🇦 retweeted
Jeffrey Heer@jeffrey_heer·27 Feb 2024

Interact with millions of data points in real-time with Mosaic, now with support for geospatial data. Exploring 1M taxi pickups and dropoffs in NYC:

0:22
Andrei Kashcha avatar
⟳ Ilya Boyandin 🇺🇦 retweeted
Andrei Kashcha@anvaka·9 Sep 2023

Adding a little serendipity into your A* path finding makes it 4x-9x faster at cost of accuracy. In some cases this might be an acceptable tradeoff.

0:31
Committee to Protect Journalists avatar
⟳ Ilya Boyandin 🇺🇦 retweeted
Committee to Protect Journalists@pressfreedom·22 Jun 2023

Read in #TheTorch: - CPJ’s support to exiled journalists jumped 227% in 3 years - CPJ to release report on rising threats to press freedom in Ecuador - Georgian journalist Nika Gvaramia pardoned - Bangladeshi journalist Golam Rabbani Nadim beaten to death cpj.org/thetorch/2023/06/cpj…

DonnyB avatar
⟳ Ilya Boyandin 🇺🇦 retweeted
DonnyB@donny_bertucci·30 May 2023

With millions of data entries, cross-filtering is painfully laggy Not with our (me and @domoritz) new JavaScript library FalconVis! With FalconVis, you can cross-filter your visualizations at scale with no interaction delay! Try it out! dig.cmu.edu/falcon-vis/cross… 🧵👇

Protomaps https://bsky.app/profile/protomaps.com avatar
⟳ Ilya Boyandin 🇺🇦 retweeted
Protomaps https://bsky.app/profile/protomaps.com@protomaps·1 Apr 2023

new logo! because... Protomaps is moving from being "open-core", or partly proprietary, to an open source project. The only closed part has been the basemap planet.pmtiles generation; an open source implementation is WIP here! github.com/protomaps/basemap… More updates soon!