Pub/Sub with PostgreSQL under 40 lines of Python code

Infrastructure

pub/sub messaging

SHOW HN2020

17points
5comments
#1,842of 3,028 in 2020
Top 61%of 2020 by points

How HN took it

QuietFewer than 5 comments about the project

3 positive, 0 neutral or asking, 0 mixed, 0 critical, out of 3 comments about the project.

Idea: 3 for, 0 against

The thread, comment by comment

Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.

positive neutral or mixed critical about another commenter or something else the maker

What HN said

What people liked

  • Simple, short implementation idea

    From 2 comments
    • Nice. Reminds me of a time I was learning Rust. Did a small test to get Node.JS and Rust to "communicate" via Postgres[0] I am curious if this is an approach folks actually use…
      zikani_03 on HN
    • It can be used as a more durable message queue too by following the recommendations in https://www.youtube.com/watch?v=B81nQLg4RuU
      SahAssar on HN
  • Useful for Django and websocket streaming

    From 2 comments
    • Interesting! I wonder if you could use this in a Django project with Channels, and stream database changes over websocket to the client. I think I've found a project for this…
      zach_garwood on HN
    • Yes you can. I used this same technique a long time ago, for cache-invalidation.
      vladsanchez on HN

Objections

  • Unclear whether used in production

    From 1 comment
    • Nice. Reminds me of a time I was learning Rust. Did a small test to get Node.JS and Rust to "communicate" via Postgres[0] I am curious if this is an approach folks actually use…
      zikani_03 on HN

Questions

  • Why autocommit isolation level is needed

    From 1 comment
    • Interesting! I wonder if you could use this in a Django project with Channels, and stream database changes over websocket to the client. I think I've found a project for this…
      zach_garwood on HN

Alternatives named

  • Durable message queues via recommended patterns

    From 1 comment
    • It can be used as a more durable message queue too by following the recommendations in https://www.youtube.com/watch?v=B81nQLg4RuU
      SahAssar on HN

Category, keywords, summaries and labels on this page were made by AI (Thread Reader v2) and not checked by hand. Each point links to the comments it came from.

Add a badge to your READMEShown on HackerShow
[![Shown on HackerShow](https://hackershow.org/badge.svg)](https://hackershow.org/show/24376541)