On: Scaling to 1M active GraphQL subscriptions on Postgres

[josephg]

Yep. I’d love to see an implementation of this in the wild built on top of logical decoding:

https://www.postgresql.org/docs/9.6/logicaldecoding-explanat...

[Liron → josephg]

Me too. Here are my thoughts on the current state of "realtime databases": https://hackernoon.com/why-eve-will-be-perfect-for-realtime-...

[ZitchDog → josephg]

Interesting idea. Logical encoding would give you the updated row, but how would you check it against each query to see if the query needed to be rerun? Sounds tricky.