[dgnemo]

This is basically the value proposition of Firebase & Supabase (they grew up to offer more than that, but DB as BaaS is their main product).

Regarding just using raw postgres sockets, the CONS is that it gets harder to code the client in javascript (I don't think webassembly can handle sockets yet?)

Security-wise, it can actually be done (see how firebase handles security) but you need a way (API layer? StoredProcedures?) to verity auth tokens (like JWT) sent from the clients