Hacker News Reader

You don't need anything specific. SELECT ... FROM queue FOR UPDATE SKIP LOCKED is the secret sauce.

Would be nice to get some goodies for free, like overview, pausing, state, statistics etc. :-)

This is exactly how pgmq is implemented, + the usage of VT.