Why PostgreSQL Is the Content Source of Truth
A look at why structured relational data can be a strong foundation for a portfolio and publishing platform.
// TABLE OF CONTENTS+
05DiscussionWhy relational data?
Projects, articles, categories, tags, technologies, and skills have stable identities and relationships, making PostgreSQL a natural source of truth.
| Approach | Strength | Tradeoff |
|---|---|---|
| Hardcoded content | Simple initially | Difficult to manage as content grows |
| Generic JSON document | Flexible | Weak relational guarantees |
| Relational model | Strong relationships and constraints | Requires deliberate schema design |
// RECENT ARTICLES
01
What Actually Happens When You Visit a Website12 Sept 2026
→02Server Components Changed How I Think About React10 Sept 2026
→03Designing a Clean Data Boundary in Next.js08 Sept 2026
→04Why I Stopped Putting Database Queries in Components06 Sept 2026
→05Designing a Structured Portfolio Content Model05 Sept 2026
→06What I Actually Learned Building This Portfolio05 Sept 2026
→
OPEN
Thoughts on the article.