Title before edit: I hate programming, why did i choose this field

TL;DR: Stupid mistake, made by hours waste.

Basically, I was extracting date from the SQL db, and it was not displaying. I tried everything, heck I even went to chatgpt, and copilot. Two and half hours of trying every single thing under the sun, you know what was the issue?

SELECT task, status, id FROM mainWorkSpace WHERE user_id = @user_id

I FUCKING FORGOT TO ADD ‘date’ TO THE DAMN QUERY. TWO AND HALF HOURS. I was like, “Ain’t no way.” as I scrolled up to the query and there it was, a slap in the face, and you know what was the fix?

SELECT task, status, date, id FROM mainWorkSpace WHERE user_id = @user_id

Moral of the story, don’t become a programmer, become a professional cat herder instead.

  • slazer2au
    link
    fedilink
    English
    920 days ago

    Get yourself a debug rubber ducky mate, talk to it when you are troubleshooting might fire off a coupe more pathways to identify the problem sooner.

      • slazer2au
        link
        fedilink
        English
        620 days ago

        You can dress it up however you like.

        Holiday duck

        Professor Duck

        Tech support duck

        • @barsquid@lemmy.world
          link
          fedilink
          320 days ago

          Tech support duck looks like he’s checking out some delicious bread crumb photography on that palmtop.

    • @pantyhosewimp@lemmynsfw.com
      link
      fedilink
      220 days ago

      Long before the duck gained popularity – and I still can’t talk to a toy – I walk around and explain things to a phantom off in the corner of my mind, and I use bold hand gestures.

      • @Solemarc@lemmy.world
        link
        fedilink
        119 days ago

        Bruh, I do this all the time! Can’t solve a problem? Get up and walk around the house while I explain the issue to imaginary people!

    • Elias Griffin
      link
      fedilink
      English
      -319 days ago

      So this is the second mention of a rubber duck. I’m trying to fiercely convince myself that talking to a toy on your desk was absolutely not a real thing for adults and that this is some satire I’m missing.

      If it’s true, that’s beyond shameful for an adult. I would quit if I were next to that person’s office/cubicle so that they didn’t infect me.

      In fact, if this was a real thing, don’t even tell me. I don’t want to live with that kinda shame for my species.

      • slazer2au
        link
        fedilink
        English
        219 days ago

        I feel as though you are missing a key part. Some people are verbal debuggers, we speak what we wrote to understand it better. Now in an office environment what is more acceptable, talking to yourself or talking to a toy on the desk?

        https://en.m.wikipedia.org/wiki/Rubber_duck_debugging

        I have done this where you read the problem in your internal monologue but nothing new sparks, yet when you speak what is going on it activates different parts of your brain for the debugging process.