I happen to play Zombicide. It's cooperative board game set in some kind of post-apocalyptic, zombie-infested, world.
Despite the general theme, lots of people like it, so we play it quite a lot.
One thing that bugged us, was : in given scenario, which weapon it's best to use?
Continue reading The hard math of killing zombies in Zombicide
Some time ago, I wrote blogpost about how to pick a task from queue, without locking.
It was written in 2013, and as such it couldn't reflect everything we have now in PostgreSQL – namely SKIP LOCKED – which was added to PostgreSQL over year later.
Two people mentioned SKIP LOCKED in comments, but it was before it was committed even to git repo. But now, we have, officially released, PostgreSQL version with this mechanism, so let's see what it can do.
Continue reading Picking task from queue – revisit