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.

Isn’t the “passive aggressive licence” just MIT?

I hate to be all doom and gloom but if the government decided tomorrow that disagreeing with trump was a crime then it’s probably already too late for you.

The amount of information about people online is pretty shocking and no amount of cleaning up after yourself could save you at this point.

On the other hand, it probably won’t devolve that fast so you’re probably ok?

“we’re just trying to display <insert field here> why is this so hard? It’s a ten minute job!”

My favourite is always;

Lemme quickly write this test, it passes great, if I make this little change it’ll fail. It’s still passing, damn.

You’re not wrong but I think when you’re teaching someone just having 1 parent and 1 child class makes for a bad example I generally prefer to use something with a lot of different children.

My go-to is exporters. We have the exporter interface, the generic exporter, the accounting exporter and the payroll exporter, to explain it.

At school, the only time I used inheritance was 1 parent (booking) and 1 child (luxury) this is a terrible example imo.

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…

Imagine voting for Voldemort

In the case of docker I’m already at the point where I no longer think it’s necessary. At my current job our stack is JS, PHP and Python. 3 interpreted languages, we then build on Ubuntu and deploy on Ubuntu. I don’t think our project really needs docker, even though it does use it. We also have wasm/wasi prepping to eat Docker’s lunch.

I’m not against immutable distro’s on principle. I imagine they still have some kinks to iron out, but I haven’t looked in on them for a while.

My opinion on these things is; if it’s a superior system, then it’ll become the new standard, that’s always what happens, and the naysayers are largely irrelevant. Just like computers, smart phones, the internet, etc.

Maybe this is a case of hindsight being 20/20 but wouldn’t they have caught this if they tried pushing the file to a test machine first?

I like how at the start of the line it explicitly says “out of memory” but we’re just pretending this is some satanic bullshit.

She obviously read the error to find “kill process” and “sacrifice child” but still ignored the memory error

Add Exporters MVP

At work we have a lot of old monolithic OOP PHP code. Dependency injection has been the new way to do things since before I started and it’s basically never used anywhere.

I assume most people just find it easier to create a new class instance where it’s needed.

I’ve never really seen a case where I think, “dependency injection would be amazing here” I assume there is a case otherwise it wouldn’t exist.

I don’t know where “software engineer” started but in Australia engineers have to study for years and then do a minimum amount of study every year to keep their license. Which we don’t have to do. I’ve always been weirded out by Software Engineer even though it seems to be becoming more common.

Sure, so you just get a fine for obstructing your license plate then.

As far as I’m aware cybercrime is generally: “anything done maliciously involving a computer” intentionally sticking a drop table command over your plates because you’re expecting something to read your plate and input it into a db might count.

Id guess maybe, if I generated a string using AI and intentionally crashed their stuff, it might be crime.

I’d be more worried that this could count as some form of cybercrime.

I love when I make a small code change and then I make my PR, CI runs and some piece of code entirely unrelated fails and it’s now my job to work out how these two unrelated things are related.