New story: 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.
@worklore.dev
@worklore.devNew story: 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.
@worklore.devNew story: 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.