The experience that made me hate programming, but that's all on me
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.
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.
I would like mine blue with an army's helmet.
You can dress it up however you like.
Holiday duck
Professor Duck
Tech support duck
Tech support duck looks like he's checking out some delicious bread crumb photography on that palmtop.
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.
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.