Comment by Macha

Two self hosting tips:

If you're going to use SQLite, make sure you enable the WAL mode on the database. It makes such a huge difference to performance that I don't know why it isn't the default.

If you're going to have multiple concurrent users (or even just one user but a large number of background writing jobs, such as mirroring public repositories), then seriously consider using Postgres. Yes, theoretically it's possible to make SQLite backed applications work fine in this scenario, but Gogs/Gitea/Forgejo has not designed their application like that, so it falls over at surprisingly small sizes and migrating after the fact is painful.