
See how dictionary encoding handles cardinality
Compare repeated country codes and unique request IDs in real Parquet files, inspect dictionary metadata, and keep local array indices separate from stable identities.
Foundation
The journal / Ideas in progress
Engineering & everyday learningSoftware, systems, and the things I’m learning along the way. From first principles to AI in production.
Find something to readA little theory. A lot of practice.

Compare repeated country codes and unique request IDs in real Parquet files, inspect dictionary metadata, and keep local array indices separate from stable identities.

Write the same twelve trips in two orders, inspect actual date statistics, and distinguish column projection, candidate row groups and measured query results.