What I learned this week⌗

Software⌗

HyperLogLog in Redshift

OLTP Snowflake

In Clickhouse primary keys do not represent a unique row, it represents the sort order of how data is stored in the file system for merge tree tables

Cool Animations

Business/Finance⌗

A touch of bribery

Rattlesnakes of Arizona

Bob is hard to come by_

Math/Stats⌗

Geometric distribution: If you’ve flipped 10 tails in a row, you’re NOT “due” for heads. The next flip is still 50/50.

Exponential distribution : If you’ve waited 20 minutes for the bus, the next minute is just as likely to bring the bus as the first minute was.

Binomial Number of successes in n trials How many heads in 10 coin flips? Geometric Number of trials until first success

Travel⌗

Other⌗