Recently. I wanted to organize around a thousand short videos. I looked into software and the solutions were really integrated, media library etc. MacOS has tagging in the filesystem, but that ties me to an operating system, and didn't give me the explore related function. I wanted something that could let me browser a folder with added metadata, explore related clips etc.
After looking at all the options I could find, I realized it was easier to just build myself a little Node.JS app using sqlite for metadata, it worked great. I plugged in local ollama and whisper for transcriptions and automatic tagging, which worked suprisingly well. It's annoying needing to run a server for such a simple app, packaging it is just so heavy ... and I thought, it's really not that far off being something I could do in a single HTML file, it was pretty much just the filesystem access - then my app/content is just a folder that does what I want to on any platform without installations or configuration.
Thanks for linking the Joe Armstrong lecture, I've watched half and its wonderful.