graphql-engine icon indicating copy to clipboard operation
graphql-engine copied to clipboard

ordered delivery of events based on primary key

Open sasog23 opened this issue 4 years ago • 2 comments

would it be possible to set the Event trigger, to be able to maintain order of the events within primary key.

let say that five users made an update of the same record (id= 100). i'd like that the events would fire in exact order as the updates if the first update resulted an error in event trigger, the other events should not fire until the first event is resolved

sasog23 avatar Dec 02 '20 06:12 sasog23

What's the use-case specifically? Does the delay i.e. waiting for webhook to respond and only then process the next event work for you (or at scale) -- this considerably throttles the throughput? Is this something that can't be handled by Postgres's concurrency control?

tirumaraiselvan avatar Dec 17 '20 13:12 tirumaraiselvan

I need FIFO method within chosen unique key

sasog23 avatar Apr 02 '22 09:04 sasog23