webcoderspeed.com
4 articles
Master ClickHouse for analytics: MergeTree engines, materialized views, CDC from Postgres, dual-write patterns, and query optimization.
Master time-series data: declarative partitioning by month, partition pruning for query efficiency, TimescaleDB hypertables, automated partition creation, retention policies, downsampling with continuous aggregates.
Master TimescaleDB hypertables, continuous aggregates, compression, retention policies, and time-bucketing for sub-second time-series queries.
Design a key-value store that returns values at or before a given timestamp. Uses a hashmap of sorted (timestamp, value) lists with binary search for O(log n) get.