Hacker News new | ask | show | jobs
by dial9-1 36 days ago
postgresql has LISTEN and NOTIFY. redis and kafka have pubsub. this is a solved problem
1 comments

Isn't the point that you no longer have a connection to the client?

So you can be notified by the database, but you can't (with the stateless HTTP + loadbalancer design explained in the article) get that notification back to the client. Because the client isn't connected anymore; so how does the client know that there's new information?

*I guess there would have to be some mechanism for the database to push notifications to the client. This is not a fundamentally unsolvable or particularly interesting problem.*