Gordon Johnston

Would it make implementation easier if there was a separate component that would generate transformed output, like `` or something? This component could be more explicit in not taking dynamic...

Hi @coco98! Thanks for the reply, I think a lock would work but my main concern with a lock is the potential for a performance impact on writes to the...

Hi @coco98 I added some logging to production that records the max difference between 'transaction_timestamp' and 'clock_timestamp' on the rows inserted into the table I want to track. We see...

Hi @coco98 sorry for the extended delay in replying. Let me outline the architecture I currently have in place that I am hoping to move to Streaming Subscriptions. It's how...

I'll explain a little more about the 'notify' table. The idea I had is that when a record in a data table is mutated the notification of that change needs...

Thanks @ilijaNL that's a really interesting and creative suggestion. I guess it could cause the delay in the client receiving the response to double, but that could be countered by...

Ah yeah I guess I shouldn't say 'at least once' as such. The client is managing it's own position and refreshing data as necessary if there is a disconnect or...

@coco98 excellent pleased to hear it. I'll look forward to giving it a go :)

Thank you @ilijaNL the insight to take the transaction lock in a deferred trigger has worked very nicely. What I have tested is this process * User writes to 'data'...

I second this request. I need to support subscriptions for clients that do not allow websockets, usually because a corporate firewall drops them. I currently have code that works around...