Cheap audit logs in ClickHouse: the schema we're using for Basira's command log
Audit logs in Postgres get expensive fast. Here's the MergeTree schema we designed for Basira's command audit trail — actor-first ordering, monthly partitions, LowCardinality enums, ZSTD-compressed payloads, and TTL-based retention.