Cockroach and change stream

[gedw99]

Would having a change steam from cockroach be a good thing ?

You would no longer be polling from graphjin but instead being fed the changes from the db .

there is golang code to do the same thing for other databases in the Wal-g project .

there might be other good aspects to this that I am not aware of I suspect

[dosco]

It would not help just getting changes as there is no way we can match queries against the changes etc. Also as it would pipe huge amounts of change data to GraphJin instances it would be very hard to scale and keep GraphJin performant. Our live query (subscriptions) implementation is lite, fast and very flexible even if you have hundreds of GraphJin instances it would scale nicely.

[gedw99]

thanks @dosco
yep thats what i also thought, but wanted confirmation.