Event Driven Read Side Update Optimizations using LISTEN NOTIFY in addition or rather than polling

[firehooper]

Has anyone looked into read side optimizations using LISTEN NOTIFY rather than polling (or using a slow long poll as a backup and use the listen notify to trigger the poll)? We use query by tags with a custom jsonb dao and legacy and it seems like we could use these built in functions similar to Elixir's commanded/eventstore . I will give it a try, but wanted to see if anyone had tried this already.

Related:

1. https://github.com/commanded/eventstore/blob/bc5d6dd6e4f1d54efc667b66197486fe79f8f087/guides/Subscriptions.md
2. https://jdbc.postgresql.org/documentation/head/listennotify.html
3. https://discuss.lightbend.com/t/bridging-write-to-read-side-persistence-query-polling/1037/5

Thanks

[nremond]

@mkubala , I think we discussed this at the genesis of the project but I don't remember why we discarded it?