Artur Jurat

@ehrlichja no investigation in that direction was done yet, i'm currently pretty busy with other stuff, can come back to this after a couple of weeks, happy to get some...

ah, just discovered that my solution won't work since fang can have a unique task in 'new' and 'in_progress' states at the same time so probably the WHERE clause of...

How about using a [PG advisory locks](https://www.postgresql.org/docs/current/explicit-locking.html#ADVISORY-LOCKS) when the unique task is scheduled/inserted in the `AsyncQueue::schedule_task`, `AsyncQueue::insert_task`? Not sure though if other databases have smth similar. The https://github.com/ayrat555/fang/blob/0.10.4/fang/src/asynk/queries/find_task_by_uniq_hash.sql will need...