Mosaic
Mosaic는 대규모 데이터 시각화와 상호작용을 지원하는 프레임워크로, 데이터 시각화 컴포넌트들이 중앙 코디네이터를 통해 쿼리를 관리하고 최적화한다. DuckDB를 백엔드 데이터베이스로 활용하며, 웹 브라우저 내 WebAssembly로도 실행 가능하다. Mosaic은 파라미터와 선택(selection)을 통해 컴포넌트 간 연동과 동적 쿼리를 지원하며, 대규모 데이터셋(수백만 건 이상)도 효율적으로 처리할 수 있는 최적화 기능을 갖추고 있다. 여러 패키지로 구성되어 있으며, UW Interactive Data Lab과 CMU Data Interaction Group의 연구 프로젝트로 개발 중이다.
https://idl.uw.edu/mosaic/what-is-mosaic/
#datavisualization #interactive #duckdb #webassembly #mosaic
How to get the Openstreetmap buildings/polygones from a list of addresses
https://katharinabrunner.de/2026/05/how-to-get-the-openstreetmap-buildings-polygones-from-a-list-of-addresses/
Dewey Dunnington revisits his 2024 benchmark of #spatialjoin operations on 130 million points, now testing #SedonaDB and #DuckDB #Spatial in comparison to the original tools. The results are remarkable: 6 seconds on a laptop replacing 3-5 minutes and 50 GB of RAM, a 30x-50x speedup achieved in just over a year.
DuckDB Labs released #DuckLake 1.0 - a data lake format that stores table metadata in a SQL database, rather than spreading it across object storage files.
Key features:
• catalog-stored small updates
• improved sorting and partitioning
• compatibility with Iceberg-style data features
Learn more ⇨ https://bit.ly/48PsPIS
Off the back of yesterday and looking at #DuckDB and the UI extension, I did a quite write-up.
Other than the issue I had around doing a lot of schema changes, it's a really nice UI which doesn't make you feel like you've ended up with the "entry level" interface.
I had a little time for a change and so thought I’d spend a bit of time exploring something different. One of the things that I find weird is the number of devs who say that they “can’t do SQL”. SQL is one of those languages that was created to allow business people to query a database using a language which makes sense to them. It has definitely grown since that lofty ideal, and of course, each database system has its own variation (called a dialect).
Also been playing with #DuckDB UI this afternoon. It’s a great place to start for exploration, and if you don’t have any UI tools available to you.
Did find out that if you’re making a lot of schema changes then it gets itself into a mess and won’t open again. So had to drop and recreate the db file a few times.
Probably do a write up on it tomorrow. Along with a Microsoft Fabric RTI demo for later in the week
sayzard
Katharina Brunner
Jan van der Laan
Spatialists
InfoQ
dazfuller 
zerok
N-gated Hacker News
Hacker News