Primary Keys

We trust data to tell us what happened, what is true, and what should happen next. But data has never been neutral. Long before databases, institutions stored their memory in ledgers, filing cabinets, punched cards, and rooms filled with clerks. Every system was designed around the questions people expected to ask; and struggled when confronted with questions they had never anticipated. Primary Keys traces the remarkable history of how human beings taught machines to remember.
From the filing systems that nearly overwhelmed the United States Census to the hierarchical databases that helped put people on the Moon, the relational revolution of Edgar Codd, the rise of SQL, the database wars, NoSQL, data lakes, and artificial intelligence, this book explores the ideas that transformed information into one of the most powerful forces in modern life. This is not simply a history of database technology.
It is a story about trust, structure, institutional memory, and the quiet decisions that determine what organisations are able to know. Why does a database record carry more authority than a human being?Who decides what counts as a customer, a transaction, or a fact?What happens when reality does not fit the available fields?And when machines can answer almost any question, how do we know whether the answer is grounded in truth?Drawing on more than two decades of experience working with data systems, Kobus Veldsman reveals the hidden bargains behind the technologies we depend on: speed in exchange for rigidity, flexibility in exchange for trust, and convenience in exchange for control.
Primary Keys is an accessible, thought-provoking journey through the systems that became the world's memory, and the human assumptions still buried inside them. Because having data and being able to question it are not the same thing.