It has a nice web interface, comes with support for auth (which almost all apps need), and has a couple other nice things like storage buckets and serverless functions. When doing a hobby project, I don't want to rent a server from hetzner, set up SSH, connect, figure out how to install postgres, make sure everything is configured and so on. It's much nicer to click one button in the supabase UI and have everything I need

I'm a happy Supabase customer. It's not just postgres, it's postgres + auth + functions + storage all in one place, with a very good local Docker environment and a variety of nice client SDKs.

It's a quick/convenient way to get a "full" backend up and running. The other option (Firebase) can't be self-hosted and has some absurd pricing footguns.

It's slow expensive postgres _with_AI_