thank you for such a detailed response. I would love to contribute however at the moment my capacities are rather limited but otherwise I’d be willing to add sqlite adapter. From your description it sounds like currently architecture is narrowly locked on PostgreSQL features. In my daily job I love PostgreSQL for big apps and stacks but I’m also aware how “hungry” PG can be, which is why I’m wondering whether it’s “too big of a hammer” for this particular problem. Also, setting up single service is easier to novices vs maintaining several. Docker compose is nice but it has it’s limitations.
self-hosting is great but that still means datacenter someplace. I’ve been using GitLab for some time now and CodeBerg “feels weird” to me. But then it could be my biases and “muscle memory”. I’d say whatever feels right for you.
Unlike other big name Git hosting company who chose to use AI to “steal” from hosted projects other two did not stoop that low. So there’s that.