I've used Supabase for some production level projects, and it's seriously a very good starting point which you can scale up to mid-tier levels. Brand new ones with no customers can easily leverage their free tier.