Skip to main content
Blog

You WILL break prod, unless...

#softwareengineering#devops#productionops#databasemanagement#reliabilityengineering

John Pratt
John Pratt
June 6, 20251 min read

You WILL break production Unless you know these 5 backend dev tips:

  1. Don't run heavy or slow code in a web request, move it to a background job - otherwise requests start piling up and response times tank.
  2. Train yourself to spot N + 1 queries. They're silent in dev, but under real traffic they hammer your database and kill your performance.
  3. If you're running an expensive query repeatedly cache the response in an in memory data store like Redis or Memcached. It'll take the pressure off the database and speed up responses.
  4. Know when to denormalize. If your data's read heavy, optimize for reads, not textbook normalization.
  5. Make your database migrations reversible. If one of them goes wrong, you'll stall the deployment pipeline and scramble to recover.

Back end isn't just about writing code, it's about not breaking stuff.

breaking prod

Follow for more dev tips!

John Pratt

John Pratt

Founder, Pratt Solutions · Previously at Northern Trust, Duke Energy, Capital One

Built enterprise systems at Northern Trust, Duke Energy, and Capital One. Now freelancing and building tools that solve hard problems at scale.

More about the author →
© 2026 John Pratt. All rights reserved. | Privacy Policy
Pratt Solutions

Let's talk outcomes.

If you're ready to ship, I'm ready to build.

I'll only use this to respond to your message. No newsletter, no marketing emails, no selling your info.