• YtA4QCam2A9j7EfTgHrH@infosec.pub
    link
    fedilink
    arrow-up
    1
    ·
    edit-2
    9 months ago

    If you can fuck up a database in prod you have a systems problem caused by your boss. Getting fired for that shit would be a blessing because that company sucks ass.

    • daq@lemmy.sdf.org
      link
      fedilink
      arrow-up
      1
      ·
      9 months ago

      Small companies often allow devs access to prod DBs. It doesn’t change the fact that it’s a catastrophically stupid decision, but you often can’t do anything about it.

      And of course, when they inevitably fuck up the blame will be on the IT team for not implementing necessary restrictions.

      Frequent snapshots ftmfw.

  • mikyopii@programming.dev
    link
    fedilink
    arrow-up
    1
    ·
    9 months ago

    I always run my queries in a script that will automatically rollback if the number of rows changed isn’t one. If I have to change multiple rows I should probably ask myself what am I doing.

  • fibojoly@sh.itjust.works
    link
    fedilink
    arrow-up
    1
    ·
    9 months ago

    A few months back I crashed a db in prod. I detached it and when I tried to reattach it simply refused, saying it was corrupted or some shit.
    Lucky me we have a backup solution.
    Unfortunately it was being upgraded, with difficulties.
    That was a long day.