Notes, learnings, and thoughts
on building a better tomorrow.
A practical look at what indexes solve, what they cost, and how to reason about them before adding one.
DatabasesWhy I Stopped Putting Database Queries in ComponentsDirect database access inside UI components feels convenient until the same content is needed in five different places.
DatabasesPostgreSQL Indexes: What They Actually Buy YouAn index is not a magic performance switch. It is an additional data structure with a cost and a specific access pattern it can accelerate.
DatabasesFlexible data is useful, but flexibility should not erase relationships that the database can enforce for you.
DatabasesTransactions: The Problem They Actually SolveTransactions are about keeping a group of database changes consistent when partial success would leave invalid state.
DatabasesDatabase Constraints Are Part of Your Application LogicValidation in application code is useful, but the database should still protect invariants that must always be true.
A look at why structured relational data can be a strong foundation for a portfolio and publishing platform.
