We should have more histories of software. There are lots of things that have been tried out and learned which if they aren’t captured will disappear entirely.

The guide to sqlite query planning and tuning is cool, but what’s even better is that this kind of scale and optimisations are possible at all with sqlite.

The situation described here where AI writes 90% of the code is almost entirely the same as how any software engineer works already. The only thing that’s changing is that instead of code you’re writing instructions to the LLM.