The Stored Procedure Debate: Why I Still Use Them
For complex financial workflows in high-throughput systems, stored procedures remain the most reliable tool I have.
DevDick / Field notes
Engineering decisions, research, setbacks and progress. A closer look at what changes—and what it means for people building software.
For complex financial workflows in high-throughput systems, stored procedures remain the most reliable tool I have.
The documentation tells you what to do. The source code tells you what is actually happening.
The algorithm gets the credit. The features do the work.
Passing a PCI-DSS audit does not mean your system is secure. It means it was secure when audited.
PHP 8+ is a different language from PHP 5. On why PHP remains the most pragmatic backend language for production shipping.
A loan summary query took 60 seconds for two years. After a schema redesign and two indexes, it ran in 4 seconds.
Currency arithmetic in floating point is broken. Here is how to build currency systems that are always correct.
Your payment API will receive duplicate requests. Idempotency is what makes the second request harmless.
Every hour you skip tests, you are taking out a loan at compound interest.
Read new published articles in your RSS reader. No account needed.
Good software starts with better questions.
Explore my work