spring-projects / spring-projects/spring-integration

Use postgres listen/notify for publish and subscribe.

Open
#4,004 6 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

status: waiting-for-reporter type: enhancement
Dominant language
Java
Stars
1.6k
Forks
1.2k
Avg merge
17h 48m
Merged PRs (30d)
62

Description

Since #3884 we can use postgres' listen/notify in conjunction with the JdbcMessageStore.

The current implementation is only for queues - but the listen/notify could be also used for publish/subscribe to broadcast messages to all listeners.

p.s.
I've got a working prototype for this adding an inbound- and outbound adapter.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Read issue #3884 and the existing JdbcMessageStore queue listen/notify implementation first. Then evaluate the proposed inbound and outbound adapters for publish/subscribe, using the working prototype mentioned in the issue if available; done means PostgreSQL LISTEN/NOTIFY broadcasts messages to all subscribers.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, postgres, spring
Domain
backend, databases, distributed-systems
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.