134
The experience that made me hate programming, but that's all on me (lemmy.ml)
submitted 5 months ago* (last edited 5 months ago) by MrOzwaldMan@lemmy.ml to c/programming@programming.dev
116 comments fedilink hide all child comments

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.

you are viewing a single comment's thread
view the rest of the comments
[-] Potatos_are_not_friends@lemmy.world 26 points 5 months ago

The difference between experienced devs and non experienced devs is that we have hundreds of stories like that under our belt. Hundreds of "Ah I wasted all this time because of a typo", and now we know to check for it.

It never stops. And after a while, a dev will share this exact scenario and you'll look back and share the same bit to them.

[-] vrek@programming.dev 4 points 5 months ago

I had that experience last week. I half blame the language though cause the way it works is you don't initialize a variable, first time you use it the language automatically makes the variable and default value is 0.

I had a variable countoot that I had a formula calculate. Then a simple if countoot > 0 do this else do that. The program kept doing that. I knew countoot should be 2. I manually did the formula ... The answer was two.

I did the same formula in 3 other programs and it worked correctly. I spent between 1.5 to 2 hours a day for like 3 days banging my head on the desk trying to figure out why it would work. Fourth day me and 2 other guys were trying to figure it out when I finally really looked closely. I realized the formula result was stored in ccountoot(notice 2 c) and the if statement was based on countoot(notice 1 c)...yeah I felt so stupid when correcting the typo fixed the problem.

[-] leftzero@lemmynsfw.com 1 points 5 months ago

first time you use it the language automatically makes the variable and default value

Now, that's just evil. 😨

[-] MrOzwaldMan@lemmy.ml 4 points 5 months ago

Thanks for sharing your experience, who knew a frustrating post written by me would give me lessons which i am going to take to heart.

[-] leftzero@lemmynsfw.com 1 points 5 months ago

The difference between experienced devs and non experienced devs is that when seeing "the experience that made me hate programming" and "date" in the same post experienced devs just stop reading (mostly due to the PTSD hit) and assume it must have been some date format issue or shudder timezone shenanigans between the database and the programming language...

this post was submitted on 11 Jun 2024
134 points (82.5% liked)

Programming

17314 readers
78 users here now

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person's post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you're posting long videos try to add in some form of tldr for those who don't want to watch videos

Wormhole

Follow the wormhole through a path of communities !webdev@programming.dev

founded 1 year ago
MODERATORS
snowe@programming.dev
Ategon@programming.dev
MaungaHikoi@lemmy.nz