zlacker
[parent]
[thread]
3 comments
1. RedShi+(OP)
[view]
[source]
2023-11-20 17:54:52
All these job queue implementations do the same thing right, SELECT ... FOR UPDATE SKIP LOCKED? Why does every programming language need its own variant?
replies(1):
>>rockwo+O1
◧
2. rockwo+O1
[view]
[source]
2023-11-20 18:01:00
>>RedShi+(OP)
To work with each language's drivers
replies(1):
>>RedShi+3o
◧◩
3. RedShi+3o
[view]
[source]
[discussion]
2023-11-20 19:21:39
>>rockwo+O1
But it's the same thing every time. Turn autocommit off, run the SELECT, commit, repeat? Or am I missing something?
replies(1):
>>ddoria+1z2
◧◩◪
4. ddoria+1z2
[view]
[source]
[discussion]
2023-11-21 09:30:40
>>RedShi+3o
You just do the update with skip locked and finish the job until time runs out or update the job "liveness". (can be autocommit on & off)
[go to top]