News for hackers. Stuff that matters.
Re:System design hack: Postgres is a great pub/sub and job s... by disiplus on Friday November 08, 2019 @03:29PM (#21486379)
at this point why not use something like rabbitmq and not reinvent it in postgres.
Re:System design hack: Postgres is a great pub/sub and job s... by stickfigure on Friday November 08, 2019 @03:47PM (#21486542)
Because it's trivially easy. The dequeue operation updates the last_lease time; the query makes sure you don't dequeue something that was recently leased. It's far, far easier than setting up a separate job queue, especially if you are already using an RDBMS.
Re:System design hack: Postgres is a great pub/sub and job s... by rapind on Friday November 08, 2019 @03:46PM (#21486533)
Because then you're running and maintaining another service. Might make sense, but depends.