Comment on I accidentally removed the WHERE clause from my SQL query in a personal tool. Every row is now the same. I lost everything, have no backup, and I'm stupid.

finestnothing@lemmy.world ⁨1⁩ ⁨year⁩ ago

• Aurenkin@sh.itjust.works ⁨1⁩ ⁨year⁩ ago

  Completely agree, transactions are amazing for this kind of thing. In a previous team we also had a policy of always pairing if you need to do any db surgery in prod so you have a second pair of eyes + rubber duck to explain what you’re doing.

  source
• tomorrow_famous@feddit.uk ⁨1⁩ ⁨year⁩ ago

  They are - until you leave them open and go home…

  source

  • finestnothing@lemmy.world ⁨1⁩ ⁨year⁩ ago

    Temporarily locked overnight >>> broken stuff in prod

    source
• fmstrat@lemmy.nowsci.com ⁨1⁩ ⁨year⁩ ago

  This is the way.

  source