Programming Throwdown
Programming Throwdown
Patrick Wheeler and Jason Gauci
169: HyperLogLog
1 hour 29 minutes Posted Nov 27, 2023 at 3:00 pm.
How To Tell When Your Car Battery Is Dead?
Tech Layoffs: Should You Care About Them?
Building a killer shader in 2 Minutes
Cerebral Cross-Over: Robot Rascals
Virtual Reality: The Next Big Thing
Are There Million PlayStation Users Who Only Play One Game?
Book of the Week: Hyperloglog (2008)
Should You Feel Bad For An AI?
Factorio Unsatisfactory: Tectonica (
What is the ESP32 Development Board
8266: Would You Need to Buy a 1000 of them?
Hyperloglog
HashMap and linked list
Hashmap and Bayesian inference: approximate K nearest neighbors
Log Log
Taking a guess with a 32-bit probabilist
Hyperloglog
Can Google Guess How Accurate is Their Hashing?
Using hyperloglog in data science
Hyperlog Log
Quantum Algorithms Explained
A message for long-time patrons
Did You Guys Buy Bitcoin?
0:00
1:29:33
Download MP3
Show notes

Intro topic: Testing your car battery

News/Links:

Book of the Show

Patreon Plug https://www.patreon.com/programmingthrowdown?ty=h


Tool of the Show


Topic: HyperLogLog

  • Motivation
    • Cardinality Counting
  • LinearCounting
    • Hash + expectation of collision based on how full
    • Bloom Filter
  • LogLog
    • Use first N bits as bucket
    • Use max sequential 0s in each bucket
    • Average
  • HyperLogLog
    • Handle empty buckets
    • Use correction factor like linear counting for low counts (number of empty buckets) and high counts
  • Distributing

    • Transfer bucket counts

★ Support this podcast on Patreon ★