Do you need Redis? how to get away with just Postgres

• Redis

  317 64,705 9.7 C

  Redis is an in-memory database that persists on disk. The data model is key-value, but many different kind of values are supported: Strings, Lists, Sets, Sorted Sets, Hashes, Streams, HyperLogLogs, Bitmaps.

  

It would have been better to frame it more generically as "adding another store or db".

But the official self-description of Redis is the following:

> Redis is an open source (BSD licensed), in-memory data structure store, used as a database, cache, and message broker.

Quote: https://redis.io/

• good_job

  35 2,439 9.3 Ruby

  Multithreaded, Postgres-based, Active Job backend for Ruby on Rails.

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• BeanstalkD

  14 6,467 0.0 C

  Beanstalk is a simple, fast work queue.

  

For use case 1 (job queue) I can only recommend beanstalkd[1]. Simple tcp plain text protocol. Install and forget. Plus you get some really useful features like deferred jobs, burying, kicking, job priorities, etc.

We have literally processed tens of billions of jobs without a single failure.

Old and simple technology that just works

[1] https://beanstalkd.github.io/

• pg-boss

  12 1,615 5.5 JavaScript

  Queueing jobs in Node.js using PostgreSQL like a boss

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

• worker

  19 1,633 9.7 TypeScript

  High performance Node.js/PostgreSQL job queue (also suitable for getting jobs generated by PostgreSQL triggers/functions out into a different work queue)

  

A great job queue for PostgreSQL running on Node.js https://github.com/graphile/worker

I've been very happy with it.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

Suggest a related project