Reporting Queries Without Destroying Production
How to handle dashboards, aggregates, indexes, and replicas with production safety in mind.
All
All posts
MySQL vs PostgreSQL Thinking for Backend Developers
Differences worth knowing when designing schema, JSON fields, indexes, and transactions.
Sorting, Filtering, and Searching Before the Database
Knowing when application-side work is acceptable and when the database should do it.
Trees, Graphs, and Permissions in Real Products
How hierarchies and relationships appear in teams, menus, categories, and access control.
Observer, Events, and Side Effects
How to use events for separation without making behavior impossible to trace.
Adapter Pattern for Third-Party APIs
Protecting business code from payment, SMS, CRM, and external service changes.