zlacker

[return to "River: A fast, robust job queue for Go and Postgres"]
1. RedShi+Ct[view] [source] 2023-11-20 17:54:52
>>bo0tzz+(OP)
All these job queue implementations do the same thing right, SELECT ... FOR UPDATE SKIP LOCKED? Why does every programming language need its own variant?
◧◩
2. rockwo+qv[view] [source] 2023-11-20 18:01:00
>>RedShi+Ct
To work with each language's drivers
◧◩◪
3. RedShi+FR[view] [source] 2023-11-20 19:21:39
>>rockwo+qv
But it's the same thing every time. Turn autocommit off, run the SELECT, commit, repeat? Or am I missing something?
◧◩◪◨
4. ddoria+D23[view] [source] 2023-11-21 09:30:40
>>RedShi+FR
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]