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.