Hacker News Reader

You could probably get a poor's man version of this by setting up materialized views, a trigger on those views, and then write code in the trigger that pushes updates onto a queueing system. It wouldn't be quite as convenient, but would probably accomplish what you want in many situations.

View on HN

This exists: https://github.com/omniti-labs/pg_amqp

This is another similarly stalled project: https://github.com/skariel/webalchemy

This project has not been updated in almost two years.

Has AMQP changed substantially in two years? For purposes of publishing a simple event?

Looking over the fork graph: https://github.com/omniti-labs/pg_amqp/network there are clearly people with that feel that status-quo release is missing features, etc.

I thought you could not do row-level triggers on views in Postgres: http://www.postgresql.org/docs/9.4/static/sql-createtrigger....

Reply on news.ycombinator.com