• 0 Posts
  • 39 Comments
Joined 2 years ago
cake
Cake day: June 16th, 2023

help-circle
  • I had a fun one this week! I needed to make an SQL query that would aggregate rows by invoice and date, but only aggregate 5 then overflow to a new row. I also needed to access the individual row data because the invoice items weren’t summed, they were displayed on separate columns!

    I ask my senior if there’s an easy way to do this, he comes back with “chatgpt says you can assign row numbers then get individual row data with % row number”

    I go to Gemini and ask “how to aggregate rows by 5 and get individual row data out?” It says “you can’t” (since when has Ai’s been able to say you can’t do X) So I ask it about the modulo operator and it gives me an example that doesn’t really work. After screwing around for a while I give up and decide I’ll just run this query 3 times. 1 for rows 1-5 then for 6-10 and one more for 11-15 that’s so many rows surely no one will break this.






  • I agree with you, it was more of a commentary on “what would happen if we had AGI tomorrow”.

    We’ve been 3 months away from AGI for a few years now and it’s debatable if we’ll ever get there with LLM’s. Looking into the results of AI tests and benchmarks show that they are heavily gamed (tbf, all benchmarks are gamed.) With AI though, there’s so much money involved, it’s ridiculous.

    Fortunately it looks like reality is slowly coming back. Microsoft’s CEO said that something like “AI solutions are not addressing customer problems.” Maybe I’m in a bubble but I feel like overall, people are starting to cool on AI and the constant hype cycle.


  • I’d agree that in the short term, AI is overhyped and in the long term, who really knows.

    One thing I’ve always found funny though is that if we have AI’s that can replace programmers then don’t we also, by definition, have AI’s that can create AI’s? Isn’t that literally the start of the “singularity”, where every office worker is out of a job in a week and labourers only lasting long enough for our AI overlords to sort out robot bodies?






  • Same, I always remember this with interfaces and inheritance, shoehorned in BS where I’m only using 1 class anyway and talking to 1 other class what’s the point of this?

    After I graduated as a personal project i made a wiki for a game and I was reusing a lot of code, “huh a parent class would be nice here”.

    In my first Job, I don’t know who’s going to use this thing I’m building but these are the rules: proceeds to implement an interface.

    When I have to teach these concepts to juniors now, this is how I teach them: inheritance to avoid code duplication, interfaces to tell other people what they need to implement in order to use your stuff.

    I wonder why I wasn’t taught it that way. I remember looking at my projects that used this stuff thinking it was just messy rubbish. More importantly, I graduated not understanding this stuff…