zlacker

[return to "Do you really need Redis? How to get away with just PostgreSQL"]
1. fiznoo+t41[view] [source] 2021-06-12 18:13:30
>>hyzyla+(OP)
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

◧◩
2. queich+691[view] [source] 2021-06-12 18:53:40
>>fiznoo+t41
Out of curiosity, how many jobs are you queuing on average and how did it perform for you at that level?

I have been thinking about using the library, mainly because it's less operational hassle than running another service that has to be sticky to one host with persistent storage and backups.

◧◩◪
3. fiznoo+ID4[view] [source] 2021-06-14 07:05:35
>>queich+691
We are using it quite lightly at the moment, only a few jobs per second, and with the worker running in the same thread as the publisher. The scheduled jobs feature is nice too, replacing the need for a recurring crib job. So far our experiences have been positive!
◧◩◪◨
4. queich+zY4[view] [source] 2021-06-14 11:30:26
>>fiznoo+ID4
Thanks!
[go to top]