Ilya Boyandin 🇺🇦

We just launched Foursquare Spatial Desktop – a geospatial analysis tool powered by embedded DuckDB and built on sqlrooms.org. Everything runs locally. A modern reimagining of Kepler.gl. Mac only for now. foursquare.com/products/spati…

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 👇 @foursquare/foursquare-introduces-sqlrooms-b6397d53546c" target="_blank" rel="nofollow noopener">medium.com/@foursquare/fo… #SQLRooms #DataApps

@EgorKotov Oh no worries at all

@ilyabo sorry, I forgot to tag you here, because I forgot that you also on Twitter

Time resolution of this mobility data is also incredible. See the animation. Then do it yourself, just follow the guide: ropenspain.github.io/spanishoddata/… #rstats #spanishoddata devs: @EgorKotov, @robinlovelace , data: @transportesgob, @_nommon , vis: Ilya Boyandin

Airfoil – ciechanow.ski/airfoil/

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:

@rhatr Get better soon!!!

Still in the ER of Oxford hospital. Wish me luck.

@TiAnastasiia @vadymnes 💙💛

@vadymnes Зайшла на flowmap.blue, які вони молодці з підтримкою України.

Day 17: Flow at #30DayMapChallenge Topic: Refugees from Ukraine in European countries Tool: flowmap.blue Data: data2.unhcr.org/en/situations/…

@sensenol03 Sorry, @sensenol03, I am not familiar with Power BI

@ilyabo Hi Ilya, I’m using your library for flowmapblue in R and I really like it. So many thanks for creating it! However, I have a problem I need your help with; how can I visualise the map created in R in power bi?

Published version 0.1 of the JavaScript geoarrow/deck.gl-layers library! Now it's just one function call to render a GeoArrow table in deck.gl with amazing performance. Fully binary. 🚀 github.com/geoarrow/deck.…

Bird migration in Europe tracked by GPS.

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.

All @OvertureMaps places - 60 million of them - displayed in @maplibre with a 3.7GB tile archive: bdon.github.io/overture-tiles… instructions github.com/bdon/overture-… 2 steps @duckdb parquet -> CSV @felt tippecanoe CSV -> pmtiles Thanks @Maxxen_ @opencholmes for the tips!

Exploring efficient, vectorized geospatial operations in the browser with GeoArrow and GeoRust compiled to WebAssembly. @kylebarron/prototyping-georust-geoarrow-in-webassembly" target="_blank" rel="nofollow noopener">observablehq.com/@kylebarron/pr…

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/…

With Flowmap.blue built by @ilyabo, anyone can create visually attractive and informative representations of data on geographic movements. Learn how it's built with Mapbox GL JS: buff.ly/3pl0beA #BuiltWithMapbox #datavisualization #gischat

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/cro… 🧵👇

Great searchable collection of old maps, if you haven't seen it yet archive.org/details/david-…

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/base… More updates soon!

@peterbraden @bububnik Hey Peter, sorry for late reply :) github.com/ilyabo/flight-… Let me know if you want to build it further

@ilyabo @bububnik But actually, I’d love to see the code, is there a repo?

#30DayMapChallenge Movement Another take on visualizing the scenic paragliding flight piloted by @peterbraden Try it live: flight-replay.netlify.app

Protomaps - vector tiles without the tile server youtu.be/dF9UuVKOf34 via @YouTube