Have been self-hosting this on a raspberry pi for the last 2 years, and it has been completely painless. It just keeps chugging along without needing to take a look.

Postgres makes sense if you take into account the paid hosting option (which is what I use), which requires multi-tenant support. I agree, SQLite would be way more convenient from a hosting standpoint, but minimalism on the user side does not have to mean minimalism on the hosting side.