Yeah i am also terrified by python. Before synapse was in apt i had to instal it using pip and virtual env and it was nightmare for me.

I run it on some 3usd vps i dont remember 1gb ram i think and use sqlite (its very portable this way). For about 20 people it works great.

It is not exactly efficient but overall still cheaper and better than other solutions ive found.