Surprisingly to remove small numbers of rows in multiple tables (e.g. cleanup between automated tests), DELETE is often faster than TRUNCATE! It's counterintuitive but just measure it for yourself and see. Note you can DELETE from multiple tables in one statement using CTEs, and that way you don't need to think about foreign key dependency order.

"the machine can’t even write good yet"

That fragment of OP’s writing was so funny to me I’m not sure it isn’t intentionally placed.

Regardless, I would rather read a thousand pages of imperfect writing than a single page of machine slop.

It's a joke, c.f. https://www.youtube.com/watch?v=NQ-8IuUkJJc

How about instead of a contrived take-home project or doing unpaid "real work" for the company, we ask candidates to do n hours of work on an open source project?

That's real useful work, if we don't hire them they can show it off to a different hiring company, and it makes the world a better place.

Not a bad idea but the problem with real work is that you can't make it fair. You can't give everyone the same bit of real work to do. Homework problems are fine. You can make them non-contrived quite easily.

The problem with homework problems now is AI. But I think it would be quite easy to detect if someone just fed it in to Claude when you go through the code with them.

Public libraries are funded and supported by the public though. They need attention, and if you read the other comments on this post it's almost like most of these people don't even realise that public libraries exist.

That was a lovely video, thank you.

You're welcome, I also enjoyed the video very much.

I caught Claude using docker (running as root) to access files on my machine it couldn't read using it's user.

Naming this after a distopia may be unintentionally apt...

I'm using Catnip (https://github.com/wandb/catnip). It runs Claude Code in YOLO mode inside a Docker container, and also manages multiple Claude instances running in Git worktrees. I'm pretty happy with it but would be happier if it addressed limiting network access to guard against exfiltration.

Consider how authorization is going to work. You can't trust the client!