I have a “to do” table, into which I insert tasks which has to be done.
Is it possible to process this in parallel from multiple consumers (processors) guaranteeing ?
I know this is something which is generally done with a message queue, but I have attached tables, and solving this in cockroach db makes it possible to do atomic modifications in all of them, and not requiring another component, making this easier.
The number of consumers are generally stable, but can change into any direction occasionally.
Is there a good advice on how to do this in cockroach?