Tag
clickhouse Articles
Data strategy insights, analytics best practices, and lessons from real projects.
Data Engineering
ClickHouse in Consulting Practice: When We Reach for It (and When We Don’t)
Fifteen production ClickHouse deployments later: when it earns its keep, when it bites, and how we decide between ClickHouse, Postgres…
Data Analytics
Cumulative Sum in SQL: 3 Approaches Compared with Benchmarks
Use window functions for running totals. When you can't, self-join works but pays an O(n²) tax. Benchmarks, code, and failure…
Data Engineering
ACID for Analytics Engineers: Why You Need It Until You Don’t
ACID for analytics engineers without the textbook. Where it breaks in dbt, ClickHouse, Snowflake pipelines, and how to design around…