So I'm checking out #Epicyon https://libreserver.org/epicyon/ (which I discovered thanks to @atomicpoet), which might be just the kind of AP server I'm looking for. I delved into the code to check how it stores the data and it seems it's going with the “static files” approach over the DB used by basically anything else, and this is pretty much what I was hoping for (I'd be OK with something lightweight like sqlite to cache the metadata for speed, this one seems to use text for that too?)
1/
I browsed some random parts of the code for this and I think I spotted an issue already: Update (edit) message processing only compares the content and summary to see if anything actually changed, but I think the logic will potentially miss some stuff (changes in only one of the contentMap fields, change in the attachments or their description etc).
2/
Despite this (a limitation that should be relatively easy to fix/change; there are probably more), I'm now actually considering spinning up an experimental personal #Epicyon instance. I think this is the first piece of #Fediverse software that has made me think it might be time to set up my own plaything. It probably won't be “right now” though, but only because I have way too much stuff in my hands at the moment and the last thing I need is experimenting with a new server software.
3/
Oblomov