4 ms·
https://pypi.org/project/pq/ https://pypi.org/project/pq/ looks similar, although it looks like they use `SKIP LOCKED` instead of advisory locks. I'm not sure w
by zrail 7y ago
https://pypi.org/project/pq/ https://pypi.org/project/pq/ looks similar, although it looks like they use `SKIP LOCKED` instead of advisory locks. I'm not sure what the tradeoff is.
- fjp 7y agoSKIP LOCKED is much simpler and doesn't really have any gotchas. We had an internal library that used advisory locks which had all sorts of strange behavior we couldn't figure out until we just moved to SKIP LOCKED