Skip Navigation

Posts
1
Comments
220
Joined
2 yr. ago

  • It's partially right but led OP down the wrong lines of thinking because it interpreted the prompt as a date field being missing rather than the field named date being missing.

    Tbh I don't blame it too much here as there is kind of a base level of understanding requred to use it successfully.

  • Ah yes here you are successfully ignoring it.

    Might not be encouraging it but you seem to be defending it.

  • It made an incorrect inference, imagine how wrong it is on more complex questions.

  • There's a difference between ranting to your coworkers at lunch about a stupid mistake and typing out a full rage essay.

    Imagine the state of the sub if we all did that... Wait...

  • Fair play. SQL is pretty different from traditional programming and errors often aren't very descriptive.

    You'll need to get very familiar with fields you have included or not in your queries when using more advanced stuff like group functions as including or excluding them can alter the number of rows returned.

  • Perhaps, but we don't know and therein lies the problem.

  • You are correct I don't know the circumstances so all we can go on is what OP wrote...

  • Yes of course, but it's not the sort of thing I'd make a rant post criticising the entirety of programming about.

    It's like going to a mathematics forum and declaring "Guyz I forgot to carry a 1, screw Maths."

  • Ah I see ChatGPT is being as accurate as ever making up a created_at field completely unprompted. They've already found the correct SQL:

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

    Although I would question the sense in calling a date field "date".

  • You didn't add the date field to your query and couldn't work out why it didn't return the missing field for over 2 hours?

    Perhaps SQL isn't for you as things get waaaaay more finicky than that.

  • Hard disagree. Most trailblazing console ever with one of the strongest lineups of first/second party games we've ever seen. Yes there were some shoddy third party ports but you didn't buy it for those.

    People moan about the controller but forget it was the first time a joystick was used and the only real issue was the redundant left prong. Loved the feel of the Z button for shooting games coupled with the Rumble Pak.

  • Mmmmm fresh pasta.

    For me it is very weird, no one introduced me formally to Lemmy(no one I knew run or heard of it), it felt like it was a legend. I never really got to know how good it was and always felt Reddit and Twitter were lacking, never really in control of your memes, never happy with my content, always downvoting stuff. The years went by and my curiosity only became larger as Reddit and Twitter experience was getting worse and worse. I already had experience shit posting and trolling on 4chan since my school days, so last year I signed up to Lemmy and posted my first meme. Next thing I know my feed is breathing again, the grass was definitely greener here. So I switched for both reasons.

  • πŸ‡ΊπŸ‡Έ "Baadel a waader" πŸ‡ΊπŸ‡Έ

  • Least contrarian Linux user.

  • Oh right I see it's like a quality vs quantity thing. To me I'd pick quality (as that is what triggers my nostalgia).

    If I want quantity there are thousands of modern indie games I'd rather play.

  • I agree, not common, which is why I don't understand the "only 20 or so great games" take.

  • Can you list 20 great first party games on any platform?

  • Yep, chuck Rumble Pak in there too.

    Did platform fighters exist before Smash?

    Did proper 3D platforming with free camera exist before Mario 64?

    Did third person adventure games exist before OoT and has anything drastically changed the formula since?

    Not to mention all these games shipped fully built with no updates and amazingly few bugs.

    It seems as though OP didn't actually experience these things at the time so making a post about nostalgia for them is strange. Firing up an emulator and going "These games don't hold up now." is entirely missing the point.

  • Pretty sure the aforementioned list makes up for one mid Castlvania game.

  • We referred to Rare as a "second-party" developer at the time. So sad when they got bought by M$.

    To answer your question on third-party games, some of my favourites were...

    Star Wars: Rogue Squadron

    Star Wars: Episode 1 Racer

    Star Wars: Shadows of the Empire

    Vigilante 8

    Extreme-G

    Snowboard Kids

    Turok

    Bomberman 64

    Resident Evil 2

    San Francisco Rush