dwyl / dwyl/learn-postgresql

Database Normalization + Denormalization ?

Open
#72 1 comment 0 reactions 0 assignees View on GitHub
discuss enhancement help wanted question technical
Dominant language
JavaScript
Stars
346
Forks
37
PR merge metrics
No merged PRs in 30d

Description

While porting Hits from Node.js (with a filesystem "db") 🐌 to Phoenix 🚀with PostgreSQL 🐘
for: https://github.com/dwyl/product-roadmap/issues/7 / https://github.com/dwyl/hits/issues/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 #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

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.