Notes, learnings, and thoughts
on building a better tomorrow.
A request looks simple from the browser, but a surprising amount of software sits between typing a URL and seeing pixels.
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.
DatabasesHow I Think About Database Schema DesignSchema design becomes clearer when you start from entities, relationships, constraints, and query patterns rather than tables alone.
DatabasesWhat a PostgreSQL Query Is Really DoingA SQL query is a request for a result, but PostgreSQL still has to decide how to produce that result efficiently.
DatabasesNormalization Without Cargo CultingNormalization is useful because it reduces contradictory copies of facts, not because every database must maximize table count.
