My main (and truly only issue) with #snac is it's overreliance on filesystem operations. it's very cool from a purely unix kind of standpoint where you can see the elegance of such a design, but in practice, it's just way too much overhead
Having it operate with sqlite instead, as a baseline, would already make it much more efficient than it is
I do like that people are engineering stuff like this though, having the entire program be a self contained repository of readable C, that implements the basic features of mastodon, is kind of dope!