Show HN: An SQS Alternative on Postgres

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Scout Monitoring - Free Django app performance insights with Scout Monitoring
Get Scout setup in minutes, and let us sweat the small stuff. A couple lines in settings.py is all you need to start monitoring your apps. Sign up for our free tier today.
www.scoutapm.com
featured
CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai
featured
  • pgmq

    A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.

    One of the appeals of doing MQ in Postgres is being able to submit events atomically in same db transaction as the stuff that raised the event

    Looking at https://github.com/tembo-io/pgmq/tree/main/tembo-pgmq-python ...how do I integrate the queue ops with my other db access code?

    Or is it better not to use the client lib in that scenario and use the SQL functions directly?

  • Scout Monitoring

    Free Django app performance insights with Scout Monitoring. Get Scout setup in minutes, and let us sweat the small stuff. A couple lines in settings.py is all you need to start monitoring your apps. Sign up for our free tier today.

    Scout Monitoring logo
  • river

    Fast and reliable background jobs in Go (by riverqueue)

  • worker

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

    People considering this project should also probably consider Graphile Worker[1] I've scaled Graphile Worker to 10m daily jobs just fine

    The behavior of this library is a bit different and in some ways a bit lower level. If you are using something like this, expect to get very intimate with it as you scale- a lot of times your custom workload would really benefit from a custom index and it's handy to understand how the underlying system works.

    [1] https://worker.graphile.org/

  • pgqueue

    Light PgQ Framework - queuing system for PostgreSQL

  • pgqueue

    PostgreSQL-backed Queue library (by cirello-io)

    https://github.com/cirello-io/pgqueue

    Hundreds of them!

    It's a good idea and easy to implement, but still valuable to have implemented already. Cool project.

  • pg-queue

    Ha, I wrote one too - https://github.com/mattbillenstein/pg-queue/blob/main/pg-que...

    Roughly follows the semantics of beanstalkd which I used once upon a time and quite liked.

  • pg_tier

    Postgres Extension written in Rust, to enable data tiering to AWS S3

    pgmq.archive() gives us an API to retain messages on your queue, its an alternative to pgmq.delete(). For me as a long-time Redis user, message retention was always important and was always extra work to implement.

    DLQ isn't a built-in feature to PGMQ yet. We run PGMQ our SaaS at Tembo.io, and the way we implement the DLQ is by checking the message's read_ct value. When it exceeds some value, we send the message to another queue rather than processing it. Successfully processed messages end up getting pgmq.archive()'d.

    Soon, we will be integrating https://github.com/tembo-io/pg_tier into pgmq so that the archive table is put directly into cloud storage/S3.

  • CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Show HN: PgQueuer – Transform Your PostgreSQL into a Powerful Job Queue

    23 projects | news.ycombinator.com | 18 Aug 2024
  • Do you need Redis? PostgreSQL does queuing, locking, and pub/sub

    12 projects | news.ycombinator.com | 3 Nov 2024
  • Pg-boss: Queueing jobs in Postgres from Node.js

    1 project | news.ycombinator.com | 27 Aug 2024
  • Fast and reliable background jobs in Go

    1 project | news.ycombinator.com | 3 Jul 2024
  • River: Robust high-performance job processing system for Go and Postgres

    1 project | news.ycombinator.com | 15 May 2024