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.

MonkCanatella@sh.itjust.works ⁨8⁩ ⁨months⁩ ago

• drekly@lemmy.world ⁨8⁩ ⁨months⁩ ago

  Me only know caveman. Not have big brain only smooth brain

  source
• groucho@lemmy.sdf.org ⁨8⁩ ⁨months⁩ ago

  Yep. If you’re in a situation where you have to write SQL on the fly in prod, you have already failed.

  source

  • Malfeasant@lemm.ee ⁨8⁩ ⁨months⁩ ago

    Tell that to my former employer…

    source

    • groucho@lemmy.sdf.org ⁨8⁩ ⁨months⁩ ago

      Yeah, I swear it’s part of the culture at some places. At my first full-time job, my boss dropped the production database the week before I started. They lost at least a day of records because of it and he spent most of the first day telling me why writing sql in prod was bad.

      source
  • MonkCanatella@sh.itjust.works ⁨8⁩ ⁨months⁩ ago

    it’s time to commit sqlpukku

    source
• olafurp@lemmy.world ⁨8⁩ ⁨months⁩ ago

  Raw dog is the fastest way to finish a task.

  • productivity
  • risk

  It’s a trade-off

  source

  • Sharpiemarker@feddit.de ⁨8⁩ ⁨months⁩ ago

    There’s no way you’re endorsing the way OP handled their data right?

    source

    • olafurp@lemmy.world ⁨8⁩ ⁨months⁩ ago

      No, but people are sometimes forced to do these things because of pressure from management and/or lack of infrastructure to do it in any other way.

      Definitely don’t endorse it but I have done it.

      source

      • Sharpiemarker@feddit.de ⁨8⁩ ⁨months⁩ ago

        Got it. I’m with you.

        source