can anyone share what the benefit is over using a self hosted repository host over a service like github/gitlab? obviously you get more power over the interface & such but are there truly any gains over using the larger platforms?
I regularly have to upload multi GB images to a VPS and it's very annoying when it takes like 10 minutes.
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.
- Not all projects are suitable for hosting by third parties (you may not want to give away the special sauce behind your wannabe next trillion dollar company, or you may be handling sensitive or confidential data like medical records, etc)
- You are immune to the trending process recently referred to as enshittification that consists of providers in a consolidated market like this one giving you an increasingly worse experience to compel you into more expensive plans, i.e. you gain independence and control
- It might be a competitive advantage to your business to still have the lights on when inevitably the centralised platform becomes unavailable to most (think of trading and events like crowdstrike)