Database Normalization + Denormalization ?

[nelsonic]

While porting Hits from Node.js (with a filesystem "db") 🐌 to Phoenix 🚀with PostgreSQL 🐘
for: dwyl/product-roadmap#7 / dwyl/hits#66 ... 📈

It occurred to me that I'm making a rather large assumption about people's technical knowledge/experience of Database design in general and normalization specifically 💭

People who have never read a text book on databases will most likely not have an immediate intuition as to how to structure a database for efficient storage and retrieval.

Todo

• add a section to the tutorial Proposed Example Outline #51 explaining why we have chosen to normalize the data for efficient storage and querying.

• https://en.wikipedia.org/wiki/Database_normalization

• https://en.wikipedia.org/wiki/Denormalization

[nelsonic]

https://dba.stackexchange.com/questions/19912/is-database-normalization-dead
https://stackoverflow.com/questions/2173066/is-database-normalization-still-necessary