Articles
Concrete problems, solved without adding complexity.
We write about what we run into at work: what breaks, why it breaks, and which simple solution turned out to be enough.
-
We fixed six slow reports and kept finding the same cause
A real ClickHouse optimization case: six reports running 20 seconds to several minutes, one shared root pattern, and the before-and-after numbers.
-
Why adding layers makes reports faster
A medallion architecture adds latency before data reaches the report, but it takes the work out of the moment when someone is waiting for it.
-
Why filtering with IN makes ORDER BY LIMIT slow
A perfect index, an IN filter, and pagination ten times slower: what IN breaks under the hood, and how UNION ALL gives the engine its early stop back.
-
Why we default to ANSI SQL (and when we break the rule)
The standard as the everyday rule: readability, drama-free migrations, the optimizer on your side. Plus the one case where the engine dialect wins.