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.
Articles on engineering, systems design, startups, and lessons from the trenches.
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.