Quality post, with plenty of useful and good advice.

I’m happy to see sqlite being recommended - I think people don’t realise how resilient and performant a database it is.

Very surprising to hear you need to restart GoToSocial to add new users!