Store money as integer cents, never as a float
The claim A floating-point number cannot represent ten cents exactly, so any system that stores money in a float column will, given enough transactions, produce totals that are off...
Read articleInsights
Engineering notes, infrastructure deep dives and practical guides from the Exotecho team.
The claim A floating-point number cannot represent ten cents exactly, so any system that stores money in a float column will, given enough transactions, produce totals that are off...
Read articleThe claim When you add a third-party plugin, extension, or library to the software your business runs on, the feature list is the least important thing to evaluate. The number that...
Read articleThe claim A monitor that fetches your homepage and checks for a 200 status confirms the least useful thing about your business: that a web server is running. The failures that cost...
Read articleThe claim Give every business record a stable, public-safe identifier at the moment it is created, separate from its database primary key. The auto-incrementing integer is fine ins...
Read articleThe claim Every public SSH port on the internet receives thousands of password guesses a day within hours of coming online. The standard responses — moving the port, installing fai...
Read articleThe claim LIMIT 20 OFFSET 5000 has two defects, and the well-known one is the lesser. Yes, it gets slower linearly, because the database must produce and discard five thousand rows...
Read articleThe claim When someone leaves your company, every account they could reach should be closed or transferred before the end of their last day — and for an involuntary departure, with...
Read articleThe claim Every long-running process on a production Linux host should be a systemd unit. Not pm2, not a screen session someone detached from in the spring, not nohup & in a deploy...
Read articleThe claim A feature flag is a deployment tool with a lifespan measured in weeks. A flag that survives past its launch becomes permanent configuration nobody understands, and a code...
Read article