8 articles tagged with "databases"
Most databases only store the current state — the last write wins and history vanishes. Event Sourcing flips this on its head: store what happened, derive what is. Here's how to apply it without drowning in ceremony.
OFFSET-based pagination sounds innocent until your table hits a million rows and your database starts full-scanning just to skip the first 50,000. Here's why cursor-based pagination is the fix your API deserves.
CQRS separates the commands that mutate state from the queries that read it — giving you independent scaling, specialized models, and saner codebases. Here's when it's worth the complexity and when it's overkill.
Hardcoded fixtures make your tests brittle and your seed files a nightmare to maintain. Factories generate realistic, varied test data on the fly — here's why your test suite needs to make the switch.
Your dashboard says 45ms average. Your users say the app feels sluggish. Both are telling the truth — your average is just hiding the tail. Here's how to measure, diagnose, and tame P99 latency before it chases users away.
Your API feels fine until it doesn't. The N+1 query problem is the most common database performance bug in ORM-heavy backends — and it hides in plain sight until your database is on fire.
Deleting a database row sounds trivial — until your boss asks why the customer record vanished and nobody knows. Here is how to pick the right deletion strategy before a production incident forces your hand.
OFFSET pagination feels intuitive until your database is scanning 500,000 rows to serve page 100. Cursor-based pagination fixes the performance cliff, ghost records, and duplicate entries in one shot.