Re:PostgREST – A fully RESTful API from any existing Postgre...
by lima on Sunday March 26, 2017 @08:44AM
(#13960468)
http://debezium.io/ is a better way to do this.
It uses the logical decoding feature to get all row changes and writes them to a Kafka queue.
This means it can pick up where it left when it crashes.
Re:PostgREST – A fully RESTful API from any existing Postgre...
by ruslan_talpa on Sunday March 26, 2017 @11:58AM
(#13961386)
along the same lines https://github.com/confluentinc/bottledwater-pg
I would instead have the trigger insert a row into a "pending tasks" table - and then send a NOTIFY.