←back to thread

Postgres LISTEN/NOTIFY does not scale

(www.recall.ai)
570 points davidgu | 1 comments | 07 Jul 25 14:05 UTC | HN request time: 0.206s | source
Show context
cpursley ◴[10 Jul 25 20:42 UTC] No.44525353[source]▶
Right, plus there's character limitations (column size). This is why I prefer listening to the Postgres WAL for database changes:

https://github.com/cpursley/walex?tab=readme-ov-file#walex (there's a few useful links in here)

replies(3): >>44525747 #>>44526330 #>>44526350 #
1. denysonique ◴[10 Jul 25 22:21 UTC] No.44526330[source]▶
For node.js users there is postgres.js that can listen to the Postgres WAL and emit node events that can be handled by application code.