While you raise valid points I don’t really have a preference actually. I self host many services that all depend on a postgres db and it would be overkill to create an extra database just for seafile it’s also really easy to manage with a nice interface like pgadmin and i found it overall reliable and it can easily scale up and down according to my needs .

However the main reason i didn’t chose MySQL in the first place is simply because i don’t trust oracle for keeping MySQL open-source (i’m actually surprised it stayed open source for so long) postgres has been independent for decades so i know they’re not gonna give me up

I gave up on using it when they dropped postgres support

Pro tip : if you self host use vaultwarden. It’s 100℅ compatible with all bitwarden clients but has many more features and is lighter weight

Not really gitea but forgejo which a softfork of gitea

Well technically WordPress is free open source and self hostable. I wouldn’t say it’s the best option but it probably is the most popular. Now if you want to use it then goodluck ¯_(ツ)_/¯