Tag
This article discusses how traditional primary key designs can isolate tables, and introduces structured primary keys as an alternative approach to improve SQL query performance and maintain relational integrity.
This article explains how Spanish traders' practice of counting without thumbs influenced GnuCash's database design choice to store monetary values as integer minor units, drawing parallels to how historical oddities shape modern technology.
The author shares a personal breakthrough in understanding columnar stores while building a game engine, relating it to Trizen's ECS and ClickHouseDB.
The article critiques Redis's recent strategic direction, highlighting conflicts over licensing changes, feature bloat, and its pivot toward an 'AI context engine' positioning. It analyzes how ambitious enterprise goals have impacted the project's openness and simplicity.
The article reframes columnar storage as an extreme form of database normalization, showing how splitting attributes into position-aligned arrays mirrors normalized tables joined on an implicit ordinal primary key.