pg-amqp-bridge

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://www.rabbitmq.com/web-stomp.html

I haven't personally used either of these, but they look interesting and I'm hoping to test them out at some point: https://github.com/gmr/pgsql-listen-exchange https://github.com/subzerocloud/pg-amqp-bridge In theory, these let you use postgres NOTIFY to add messages to queues (which can be done from inside triggers).

one option to push events (jobs) into RabbitMQ using NOTIFY is this little thing https://github.com/subzerocloud/pg-amqp-bridge

Well, maybe because most application don't need/have the scale that require a messaging server? A lot of projects i would say have a 80/20 read/write split, thus, there are not so many events and they don't need the complexity of rabbitmq when the db can handle a few events. Having said all that, we did actually build a tool to connect together postgresql and rabbitmq :) https://github.com/subzerocloud/pg-amqp-bridge When you get to a big number of events or maybe there are lots of types and they all need to be routed in complex ways (real time updates) then indeed, rabbitmq is the right tool And this component enables you to execute NOTIFY in a trigger or stored procedure and have that message sent to rabbitmq.