Supabase has become my backend of choice for modern web applications. It provides PostgreSQL database, authentication, real-time subscriptions, file storage, and edge functions — everything you need to build production applications without managing infrastructure.
The CMS powering this site runs entirely on Supabase. Multiple client projects use it as their backend. This isn't theoretical — it's production experience with the platform's strengths and limitations.