Comment by crooked-v

I'm a big fan of Supabase. It's a SAAS but you can self-host the open-source stack if you want, and their big goal is to have an array of out-of-the-box services (auth, realtime push, etc) built on tight integration with a Postgres database.