Hello,
We have a workflow when we receive events into the service. But we don't have a way to choreograph or orchestrate the workflow. The services are all independent and receive and respond to events.
Since there is no order imposed by the event queues I was thinking of storing a simple state machine in the table.
1. Order PENDING
2. Order line 1 PENDING
3. Order line 2 PENDING
4. Order line 1 PROCESSED
5. Order line 2 PROCESSED
6. Order PROCESSED
Order and Order lines can be PROCESSED in any order. But at the end all lines should be PROCESSED and then the order is also PROCESSED.
I won't be able to use any PostgreSql functions because we don't depend on those features.
Are there any PostgreSql features that could support this pattern ? Is it just like any other eventually consistent pattern ?
Thanks