Build Notes and Lessons

Software Notes from Real Projects

Practical build notes and technical decisions from developing web applications and business software. Grounded in actual production code and lessons learned on the job.

Sep 5, 2026•5 min read

Why We Moved Inventory and Balance Calculations Directly into the Database

In a busy retail store, letting a website screen calculate order totals and stock can cause mistakes when multiple cashiers sell items at the same time. Here is why we made the database handle calculations directly.

Read full note