Spyke

Replies

Comment on

Works going full AI crazy. 10x the amount of projects, only half work

Reply in thread

Its pretty good at SQL

Eh 🤷‍♂️. Call it anecdotal if you want, but this is my experience:

The imbeciles who manage our ERP silently pushed some update that must have removed some indexes because suddenly several complex queries were one or two orders of magnitude slower.

While I got to work on optimizing them, a colleague who's outsourced most of his thinking to LLMs got what according to him was “the most powerful model” (some flavour of claude, I assume) to take a look at one particular affected query relevant to the project he was working on.

To be fair it went for more or less the same approach I was taking (storing intermediate results in table variables, spending memory to save speed, though it used temporary tables instead for some reason), but in a significantly more inelegant and inefficient way than I would have (for instance, it put SELECT *s — from tables with hundreds of columns! — into the temporary tables, when we only needed a few columns; an absurd waste of memory; it also missed several other optimizations, being apparently happy with “good enough” instead of trying to be thorough).

Happy with the result he pushed it into production, while I kept working on the rest of the queries, managing to also bring them back to reasonable times.

Couple days later, ticket comes in about that specific query being slow again, for particular parameters. I'm not sure what was wrong (the design of the database is absolute unadulterated shit, but it belongs to the ERP anthropoids and we can look but not touch, and have to work around it), but in some specific cases some joins produced many duplicate results, leading to massive slowdowns. While diagnosing that I also noticed that some of the values it produced weren't correct.

So I rewrote the whole thing based on the work I'd done with the other queries, and now it works properly and efficiently, and significantly faster (at least until the ERP assholes break something again).

TL;DR, sure, the machine quickly produced an apparently working solution (I don't know what the cost of the tokens was, though), in much less time than I could, but the result was ugly, poorly thought out (which, I mean, since it was made by something that can't think and just statistically processes language, I'm not sure to which extent can be a criticism of the technology, but is a criticism of those using it), less efficient than mine (and I wouldn't call myself any kind of SQL master or guru, I just meddle), and failed in some particular cases. I was not impressed.

cat

Comment on

Cats vs dogs

Reply in thread

Depends on the dog. Boxers for instance reach a certain (relatively young, for most dogs) age and just... break down, at a genetic level. Cancer everywhere.

Comment on

Generations

Reply in thread

Kings tend to have shorter lifespans, though, what with other people wanting to be king, or for someone else to be king instead of the current one, or for there to just not be any king at all...

Comment on

What scifi weapon would you want?

Reply in thread

I'm fairly certain Holtzman suspensors attract worms. (As do Holtzman shields.)

With the harvesters it doesn't matter much because the harvesting itself attracts them, but if you want to move around in Arrakis and don't want to find your vehicle eaten when you come back for it, it's probably better for it to use some mechanical means of flight, and ornithopters are probably less noisy than propellers, rotors, or jet engines. Also more capable of handling sandstorms.

anime

Comment on

[Discussion] What anime became the blueprint for future works?

Astro Boy (Tetsuwan Atom). Basically defined and kick-started anime as a genre and aesthetic. If there's a most influential anime, it's this.

Or maybe Space Battleship Yamato. It turned anime from “TV comics” into, well, anime.

Mazinger Z. Pioneered the giant mecha anime. Also Getter Robo.

Science Ninja Team Gatchaman (better known in the West for its adaptation as Battle of the Planets). The template for the super sentai team genre.

Mobile Suit Gundam. Revolutionised the giant mecha genre moving from simple good vs. evil children cartoons to complex geopolitical narratives. Also, in a similar vein, Macross.

Urusei Yatsura. The template for moe anime. See also Ranma ½.

Nausicaä Of The Valley Of The Wind. The foundation for Studio Ghibli's aesthetic, tone, and narrative.

Akira, Dragon Ball, Cowboy Bebop. Brought anime to the mainstream in the West, and Dragon Ball is a cornerstone of the shounen genre, with probably only One Piece coming close in influence.

Sailor Moon. Not the first magical girl anime by a long shot, but arguably the cornerstone of the genre. Also Puella Magi Madoka Magica, which redefined and revitalised it.

Neon Genesis Evangelion, already mentioned in the OP. Extremely influential in the 90s and noughties.

Ghost in the Shell. Took over from Akira as a cornerstone of cyberpunk anime.

And I'm surely missing dozens, I'm far from an expert in the genre.

Personally Space Pirate Captain Harlock, Doctor Slump, Dragon Ball, Urusei Yatsura, and Ranma ½,, and later Akira, My Neighbour Totoro, Nausicaä, Ghost in The Shell, and Fullmetal Alchemist were my main introductions to the genre (besides stuff that was in the background but I didn't really follow or, at the time, recognise as a specific genre), but that's just personal history and preference; I tried to list ones that seem to objectively have had significant influence on the genre or industry.