DDoogal Simpson·Mar 18Why Your Database Hates COUNT(DISTINCT) and Why HyperLogLog is the CureAvoid the memory explosion of COUNT(DISTINCT) at scale. Use the coin-flipping math of HyperLogLog to estimate millions of unique views with constant space.4 min read·doogal.dev