This looks cool, and another approach is pg_amqp_bridge to send events like this into rabbit. A nice feature is that the triggers don't block:
https://github.com/subzerocloud/pg-amqp-bridge
You can then push to websockets from rabbit with STOMP
https://github.com/subzerocloud/pg-amqp-bridge
You can then push to websockets from rabbit with STOMP
Thanks for posting this. Can already see a couple of weekends burned trying to drive celery from pg.
Do you know if it is used in production somewhere; how battle-tested is it?