LISTEN/NOTIFY — Event-Driven Database Programming
LISTEN/NOTIFY — Event-Driven Database Programming
PostgreSQL's built-in pub/sub mechanism lets processes communicate asynchronously through the database. A process sends a notification on a named channel; any process listening on that channel receives it. This is a lightweight alternative to an external message queue for intra-application communication, background job triggering, and cache invalidation.