Comment on Million User Webchat with Full Stack Flux, React, Redis and PostgreSQLparentComments−nunwuo11yHuh? The entire point of listen/notify is exactly that you don't have to poll.−fauigerzigerk11yAnd yet in previous versions of libpq polling was the only way to use listen/notify. I'm not sure if it was a limitation of libpq or the server implementation itself: http://www.postgresql.org/docs/9.4/static/libpq-notify.htmlIt's still not a particularly simple interface as you have to check for notifications after every single SQL command if I understand it correctly.
Comments
Huh? The entire point of listen/notify is exactly that you don't have to poll.
And yet in previous versions of libpq polling was the only way to use listen/notify. I'm not sure if it was a limitation of libpq or the server implementation itself: http://www.postgresql.org/docs/9.4/static/libpq-notify.html
It's still not a particularly simple interface as you have to check for notifications after every single SQL command if I understand it correctly.