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.

Used to use vscode, then one day it stopped working for me. I’ve been using Helix full time for a few months now and I’m pretty happy with it.

It’s funny, to me I’ve had an llm give me the wrong answer to questions every time.

The first time I couldn’t remember how to read a file as a string in python and it got me most of the way there. But I trusted the answer thinking “yeah, that looks right” but it was wrong, I just got the io class I didn’t call the read() function.

The other time it was an out of date answer. I asked it how to do a thing in bevy and it gave me an answer that was deprecated. I can sort of understand that though, bevy is new and not amazingly documented.

On a different note, my senior who is all PHP, no python, no bash, has used LLM’s to help him write python and bash. It’s not the best code, I’ve had to do optimisations on his bash code to make it run on CI without taking 25 minutes, but it’s definitely been useful to him with python and bash, he was hired as a PHP dev.

MDN says you’re right because innerHTML is un-escaped and you’re probably trying to use textContent. Didn’t know about this one, thanks.

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

Sony owns Bloodborne, Miyazaki can only be as involved as Sony allows. No way an exec doesn’t know this lol.

My comment was supposed to be a bit of a joke…

Generally speaking, you cannot read a file from disk using JS in the browser because the sandbox doesn’t allow the code access to your disk. If you googled something like “read a file JS” it probably made an assumption that you’re using Server side like nodejs or deno. The only exception for in-browser that I know of is to upload files using an input tag.

Are you trying to use the Lord’s JS to read files from your PC?

If it wasn’t for the game awards section at the top of the page I would’ve dismissed this as “they bought the domain from someone else” wtf it looks like some kinda cat fashion webstore.

Maybe that was a website template? IDK how to explain this lol.

Currently the game doesn’t have any AI disclosures on its steam page. I don’t know if you need to do Crypto disclosure. It doesn’t look like there is any info about this game other than a pair of CG/“in engine” trailers

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.

I don’t get why we’re taking a swing at Linus here. The article only mentions him in relation to the rust for Linux project being slow going. But, it IS going and the US government has only stated that “you need a plan to move to a memory safe language by 2025 or you might be liable if something bad happens as a result of the classics (use after free/double free/buffer overflow/etc.)” but I don’t think Linux would count it’s free software and it does have a plan.

Something I’ve always found funny about the “AI will replace programmers soon” is that this means AI’s can create AI’s and isn’t this basically the end of the economy?

Every office worker is out of a job just like that and labourers only have as long as it takes to sort out the robot bodies then everyone is out of a job.

You thought the great recession was bad? You ain’t seen nothing!

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.