Search Articles — Sudonull

Search Results

In this project

Special ClickHouse Engines: When MergeTree Is Not Needed

https://sudonull.com/special-clickhouse-engines-when-mergetree-is-not-needed

Overview of ClickHouse Memory, Buffer, Null, Log, URL, S3, and PostgreSQL Engines. Examples for coefficient cache, buffering inserts from Kafka, and live data from external databases.

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.

ClickHouse Data Types: Complete Reference for Analytics

https://sudonull.com/clickhouse-data-types-complete-reference-for-analytics

Int, Decimal, LowCardinality, DateTime64, Array, Enum, Nullable — where to save space without losing speed. Ready schema for a betting platform with examples.

Zig for network daemons: MTProto and AI experience

https://sudonull.com/zig-for-network-daemons-mtproto-and-ai-experience

Zig analysis in real projects: zero-allocation proxy, vtable for AI, comptime TLS. Comparison with C/Rust, allocation-free architecture. For middle/senior dev.

From other projects

Atletico lost to Celta 0:1 — La Liga match review

https://lrivo.com/atletico-lost-to-celta-0-1-la-liga-match-review

Atletico sensationally lost to Celta (0:1) in the 35th round of La Liga. Iglesias' goal nullified 17 shots from the hosts. Find out the details and match statistics!

Trending Now