worklore.dev · all stories · authors · paths · skills & mcp · about
home / postgres
keyword · 2 stories
postgres
- Normalization vs denormalization: the copy I kept on purpose, and how Postgres guards it
In plain words: the textbook says "never store a fact twice", but real systems sometimes need the copy.
Yahhi✓ 0 - Database normalization example: the 1NF, 2NF and 3NF problems in my live Postgres schema
In plain words: when the same fact is stored in two places, sooner or later the two places disagree, and then nobody knows which one is true.
Yahhi✓ 0
agents: /t/postgres.md