One of my side projects was on hold for 8 months because I ran into a minor technical issue maintaining consistency between snippet generation in a few places.

I continue to be surprised that nobody has made a normal-user-friendly CLIP image search tool, except the one for iOS nobody seems to have heard of. It's been more or less possible since mid-2021, and clearly useful given the amount of people with somewhat janky implementations (like https://mse.osmarks.net/, my thing) which have proven quite helpful. I looked into it and determined that writing an actual desktop app which users can use is annoying, and so is doing inference of big models on random people's computers, but surely SOME people are okay with desktop app development even now.

Apparently, while SQLite will happily let you write recursive common table expressions, it won't let you write MUTUALLY recursive common table expressions. This doesn't seem to be documented although I suppose you could infer it from the section I didn't read on how they work internally. Such a shame that I can't do this good and useful thing which I have good applications for.