Perfect is too expensive
summary
Every nontrivial app accumulates impossible rows and full prevention is unaffordable, so the talk argues for regular automated checks: a small recheck gem that introspects Rails validations, generates SQL queries, and runs them in production. It cites surprises like Stripe processing 1.4 trillion and an estimate of roughly one in 250,000 records being invalid, shows a Lobsters demo that finds 3 bad stories among ~120,000, and explains why SQL constraints or triggers alone don’t solve the problem.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 3:19Perfect validation impossible
- 8:39Trade-offs in Rails and DB
- 13:35Race conditions and state
- 18:49SQL constraints limits
- 22:21Introducing recheck
- 27:21Checks as solution
related talks
34mToo Big to Fail
39mData Corruption: Stop the Evil Tribbles
14mDatabase Performance at Scale for RoR Applications
41m(Re)Building a large scale payments system on Rails
54mDatabase Guardrails - new age for developers and databases
01h 01mNew Approach to Resolve objectrelational impedance mismatch
09mLightning talk: The 6 Characters That Could Bring Down Your App
36mData Management with Ruby