Yep. We experimented around a lot with pub/sub (listen/notify, wal-lr). But it was getting hard to scale and heavy/spiky write loads needed careful thought. This seemed like the right way to get started esp. given that Hasura can get the entire sql query including authz, before moving to tackling that problem more effectively[1].
For folks that want to play around with wal and listen/notify:
For folks that want to play around with wal and listen/notify:
https://github.com/hasura/pgdeltastream https://github.com/hasura/skor
[1] https://github.com/hasura/graphql-engine/blob/master/archite...