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.
Parser acceleration by 3 times: transition from Rust/WASM to TypeScript https://sudonull.com/parser-acceleration-by-3-times-transition-from-rust-wasm-to-typescript
Performance analysis: why abandoning WASM and porting the parser to TypeScript with an incremental algorithm resulted in 3x faster stream processing. Practical benchmarks and conclusions.
ARIA snapshots Playwright for AI agents https://sudonull.com/aria-snapshots-playwright-for-ai-agents
Learn how Playwright generates semantic YAML ARIA snapshots for web agents. Token optimization, incremental deltas, DOM processing. For middle/senior dev.