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.