Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

For me, I've considered switching away from supabase because of one major limitation: no transactions in database. Another thing is real time updates and how disconnected they are from the database (no optimistic updates, separate initialization required, different query syntax in the (JS) API, etc)

There's also other minor annoyances like not being able to deploy functions via CLI for self hosted instances and issues with running the latest versions (studio)

I'm solving the problem of no transactions by using a combination of Supabase and Prisma + Kysely.

And I know the Supabase team has been doing a lot lately to improve local development and self hosting environments. I'm sure they'll make it easy to use for us.

I think what Supabase needs more than anything else is an effective additional sales policy to sell enterprise solutions and use cases from large or high-profile companies.