Clickhouse

Cheatsheet: install, client, tables, queries.

Cheatsheet: MergeTree, Replacing, Summing, Aggregating, Collapsing.

Cheatsheet: MV basics, AggregateFunction, refreshable.

Cheatsheet: query patterns, primary key usage, projections.

Cheatsheet: codecs, LowCardinality, encoding.

Cheatsheet: shard/replica, ON CLUSTER, Distributed table.

Cheatsheet: ingest patterns, Buffer, Kafka, async inserts.

Cheatsheet: time-series, bucketing functions, rollups, retention.

Cheatsheet: window functions, retention, funnel analysis.

Cheatsheet: BACKUP TO, FREEZE PARTITION, restore.