> Also gitea is a much more lightweight option and can use sqlite for db. Much easier to deploy on a rpi

Worth mentioning Forgejo as well (https://forgejo.org), which is Codeberg's fork of Gitea. Same features and as lightweight as Gitea. Hard-forked a couple of months ago after some transparency concerns from the new parent company that owns Gitea now.