What does HackerNews think of pg-boss?

Choose Postgres queue technology | Sep 2023

For running queues on Postgres with Node.js backend(s), I highly recommend https://github.com/timgit/pg-boss. I'm sure it has it scale limits. But if you're one of the 90% of the apps that never needs any kind of scale that a modern server can't easily handle then it's fantastic. You get transactional queueing of jobs, and it automatically handles syncing across multiple job processing servers using Postgres locks.

SQL Maxis: Why We Ditched RabbitMQ and Replaced It with a Postgres Queue | Apr 2023

Expand Context ↕

There are libraries that implement queueing on top of databases that require very little setup by the user. For example https://github.com/timgit/pg-boss

SQL Maxis: Why We Ditched RabbitMQ and Replaced It with a Postgres Queue | Apr 2023

If you don't want to roll your own, look into https://github.com/timgit/pg-boss

Supabase – Realtime: Multiplayer Edition | Aug 2022

Expand Context ↕

(I'm assuming you want a queue/workflow engine)

Temporal has done an incredible job of ensuring there will be no side-effects (even with external systems), so I doubt we'll be able to do something as extensive as they have. That said, we will probably build a simple Postgres queue/workflow engine (similar to pgboss[0]). It will live in the Postgres database (as an extension), but will be nicely integrated with Edge Functions. We haven't started this yet, so I don't have any timelines.

[0] pgboss: https://github.com/timgit/pg-boss

Launch HN: Convoy (YC W22) – Open-source cloud-native webhooks service | Feb 2022

Expand Context ↕

Both! For context, we're currently using https://github.com/timgit/pg-boss as a task queue on top of postgres and it works great. No need to complicate things with Redis. I believe it's quite straightforward to implement a task queue on top of postgres using the SKIP LOCKED functionality.

Devious SQL: Message Queuing Using Native PostgreSQL | Jan 2022

If you are using node.js and looking for PgSQL based JobQueue, PgBoss (https://github.com/timgit/pg-boss) is a solid one!

Devious SQL: Message Queuing Using Native PostgreSQL | Jan 2022

> Queueing jobs in Node.js using PostgreSQL like a boss

You can scale much higher in Postgres 14 if you use partitioned tables, both horizontally and in terms of day-to-day stability because old partitions can be dropped in O(1) time, taking all table bloat with them. Obviously more work to set up, though.

Postgres is a great pub/sub and job server (2019) | Dec 2021

If anyone is looking to use postgres as a job server with node.js clients, I can highly recommend the pg-boss library (https://github.com/timgit/pg-boss). Looks like it just added pub/sub too (yesterday), so I guess you could use it for that too.

Do You Really Need Redis? How to Get Away with Just PostgreSQL | Jun 2021

We’ve seen success in our current node.js application using pgboss [1] for job queueing. Since the primary database is Postgres, it’s nice to not introduce another dependency into the system, and take advantage of the infrastructure that we already have. The library supports most of what you’d expect from a job queue, and is crucially well maintained!

That being said, I agree with other comments that this is somewhat swimming against the tide. Redis is much more commonly used, and so if you don’t mind adding another service into the mix, I’d probably recommend going with Redis instead.

[1] https://github.com/timgit/pg-boss

System design hack: Postgres is a great pub/sub and job server | Nov 2019

Expand Context ↕

https://github.com/timgit/pg-boss for node, https://github.com/mbuhot/ecto_job for elixir.

I wish all these libraries agreed on a common schema >_<

On SQS | May 2019

Expand Context ↕

There's a few libraries implementing this:

https://github.com/mbuhot/ecto_job for Elixir

https://github.com/timgit/pg-boss for Node.js

Postgres Job Queues and Failure by MVCC | Jul 2017

Expand Context ↕

Here's the one using similar approach, but for Node.js.

https://github.com/timgit/pg-boss