I run it together with ZFS and SQLite. This enables atomic snapshot of both the database and git repository. And this is of course replicated to another system. SQLite is plenty fast, people should avoid more complex solutions using PostgreSQL or MySQL. I've also configured SSO with Azure Active Directory which everyone with mail from Microsoft has access for free.
For the past few years I've completed a few dozen upgrades, only 2 times it has broken. One was a new configuration property I needed to add, and one was that I upgraded GoLang a bit too early and Gitea didn't support it. Compared to many other open source projects, Gitea is a joy to use and run. And I hope it will stay like this for another 10 years.