ClickHouse introduces lazy materialization for faster, leaner queries

April 22, 2025, 1:21 pm

ClickHouse has unveiled its “lazy materialization” feature designed to cut down data reads and drastically reduce memory usage during query execution on enormous tables. This smart optimization reads only the demanded columns, slashing query times significantly and proving a robust enhancement for modern columnar databases.

simonwillison.net / ClickHouse gets lazier (and faster): Introducing lazy materialization

clickhouse.com / ClickHouse gets lazier (and faster): Introducing lazy materialization

permalink / 2 stories from 2 sources in 6 hours ago #bigdata #software #analytics #datainfrastructure #clickhouse +

DuckDB-WASM draws 3D graphics with SQL magic

April 22, 2025, 12:21 pm

Developers have creatively repurposed SQL by leveraging DuckDB’s WebAssembly build to render 3D graphics. Through a series of clever queries that implement basic ray tracing, this hack transforms SQL into a surprising medium for graphic art, proving that even database engines can have a little fun when pushed beyond traditional limits.

simonwillison.net / Abusing DuckDB-WASM by making SQL draw 3D graphics (Sort Of)

hey.earth / Abusing DuckDB-WASM by making SQL draw 3D graphics (Sort Of)

permalink / 2 stories from 2 sources in 7 hours ago #software #dataviz #technology #developer-tools #duckdb-wasm +