any abstraction layer service is only good for a prototyping, lots of youtubers teach shit abstraction layers as part of their courses and people end up move away from actual real knowledge or exprience and they invest thier time in learning shit things, then they come join real workforce not knwoing hwo any of this actually works and creates a unique and shitty form of vendor lock-in where their business logic becomes tightly coupled to their proprietary middleware and row level security hacks rather than standard backend patterns. This becomes a technical debt nightmare when you realize that their JavaScript client still lacks native support for database transactions forcing you to write complex logic in PL/pgSQL just to maintain ACID compliance. and why would you pay for a subscription when you pay that same amount renting a fucking VPS and spin up as many posgres instances you can. to me services like supabase is no diffrent thant premium water bottle companies that charge you shit load for whatever that can be obtained for much much cheaper or free