Search Articles — Sudonull

Search Results

In this project

Three Data Aggregation Errors in BI Systems

https://sudonull.com/three-data-aggregation-errors-in-bi-systems

Learn why BI systems lie: mathematical errors in averaging, count distinct, and snapshot metrics. How to build analytics without distortions.

Robotaxi Safety During Pedestrian Aggression

https://sudonull.com/robotaxi-safety-during-pedestrian-aggression

Waymo Passenger Lock-in Incidents Due to Vandals. How Autonomous Driving Systems React to Threats and What to Do. Analysis of Real Cases for Developers.

SummingMergeTree and AggregatingMergeTree in ClickHouse

https://sudonull.com/summingmergetree-and-aggregatingmergetree-in-clickhouse

Incremental aggregation in ClickHouse: how SummingMergeTree and AggregatingMergeTree speed up dashboards by 100 times. Examples, materialized views, pitfalls, and comparison.

ClickHouse Materialized Views: triggers on INSERT

https://sudonull.com/clickhouse-materialized-views-triggers-on-insert

How MV work in ClickHouse: incremental aggregation, chains minute→hour→day, Null+Kafka pattern, POPULATE and its dangers. Examples with SummingMergeTree and AggregatingMergeTree.

From other projects

Nano-Channeling and Hydrafacial: aesthetics of health

https://ymaho.com/nano-channeling-and-hydrafacial-aesthetics-of-health

How BeautyHealth reassembles the market: nano-channeling SkinStylus enhances Hydrafacial. Learn about the new care ecosystem without aggression and pain.

1inch Explained: Smarter Crypto Swaps for Everyone

https://ymaho.com/1inch-explained-smarter-crypto-swaps-for-everyone

Learn how 1inch aggregates DeFi liquidity to save you time and money on crypto trades. No jargon, just plain English. See why it's vital infrastructure.

Trending Now