pg_notify enables real-time asynchronous messaging between the database and client. After coming from Firebase (and exploration of Supabase) this is common need for modern real-time applications, removing the need for optimistic updates, complex boilerplate heavy state-management packages like Redux/NgRx.

Caveats: This is difficult to build and maintain, requiring many custom triggers, where clause exceptions etc.

This may not be the extension to fix this issue, other PaaS services offer custom libraries to solve this solution.