
https://xitter.cf/t.co/NAjF3qTPvK geo data visualization engineer at @Foursquare. creator of https://xitter.cf/t.co/FnUcAhZpmp and https://xitter.cf/t.co/Tx1sLyx3G7. past @teralytics @ixt @unifr
Zurich, Switzerland
Joined February 2009
- Tweets752
- Following1.5K
- Followers1.2K
- Likes1.7K
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/spat…
Ilya Boyandin 🇺🇦 retweeted
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
Ilya Boyandin 🇺🇦 retweeted
Airfoil – ciechanow.ski/airfoil/
Ilya Boyandin 🇺🇦 retweeted
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:
Ilya Boyandin 🇺🇦 retweeted
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.gl-…
Ilya Boyandin 🇺🇦 retweeted
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.
Ilya Boyandin 🇺🇦 retweeted
All @OvertureMaps places - 60 million of them - displayed in @maplibre with a 3.7GB tile archive:
bdon.github.io/overture-tile…
instructions github.com/bdon/overture-til…
2 steps
@duckdb parquet -> CSV
@felt tippecanoe CSV -> pmtiles
Thanks @Maxxen_ @opencholmes for the tips!
Ilya Boyandin 🇺🇦 retweeted
Exploring efficient, vectorized geospatial operations in the browser with GeoArrow and GeoRust compiled to WebAssembly.
observablehq.com/@kylebarron…
Ilya Boyandin 🇺🇦 retweeted
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…
Ilya Boyandin 🇺🇦 retweeted
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
Ilya Boyandin 🇺🇦 retweeted
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…
🧵👇
Great searchable collection of old maps, if you haven't seen it yet
archive.org/details/david-ru…
Ilya Boyandin 🇺🇦 retweeted
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!
Ilya Boyandin 🇺🇦 retweeted
Protomaps - vector tiles without the tile server youtu.be/dF9UuVKOf34 via @YouTube
Ilya Boyandin 🇺🇦 retweeted
Finally launching github.com/dabreegster/route…! Sketch routes in #mapbox and #maplibre using a file you load once, instead of asking an API to route constantly. I'd love ideas for improving this, to see how people use it, and to get help developing it!
#rust #wasm #openstreetmap
Ilya Boyandin 🇺🇦 retweeted
#30DayMapChallenge
A hydrological map of Kenya.
Rivers in Kenya flow from the highlands East & West of the Rift valley. Eastern rivers flow to Indian Ocean, Western rivers to Lake Victoria and a few rivers flow into Rift valley lakes.
Which river(s) flow in your home County?
Ilya Boyandin 🇺🇦 retweeted
My first ever #30DayMapChallenge submission 🤗! Had to hurry it out, but it felt good to just throw a quick map together!
Thermal anomaly hotspots in Ukraine from February to July 2022 as sensed by MODIS. – at Arvada, CO
Ilya Boyandin 🇺🇦 retweeted
#30DayMapChallenge, Day 5 Ukraine
In Ukraine many villages share the same name. Each frame of animation present villages with a particular name along with their geometric centroid.
Keep in mind the last name shown in the animation: Peremoha - you will hear this word a lot soon.
Ilya Boyandin 🇺🇦 retweeted
For #30DayMapChallenge I thought I'd start with a dataset I enjoy playing with, SF Elevation Contours. I rendered it as points (day 1!) in @FSQStudio. The highest point in SF is annotated.
























