@drq just a little follow-up as I started trying them out today
Supabase turned out to be not that friendly for self-hosting. Every installation is a single project — not good, why would I even bother if I just need a simple thing to create small projects with database and auth ready straight from the web UI.
So I found out about https://appwrite.io, which is easier to host, and supports both projects and organisations out of the box (supabase only supports a single admin user, bruh!). And it is nice. It also supports running "functions" written not only in JS, but also in Go, Dart, C++, Python, Java and others.