Listening for Notifications

[factormaarten]

Hi,

Is there a good way to listen to triggers using your library?

Thanks,
Maarten

[mbonneau]

I am not sure what you mean by listening to triggers? Are you referring to the LISTEN command?
https://www.postgresql.org/docs/current/static/sql-listen.html

[factormaarten]

Sorry I did not get a notification of your reply. Yes, I am referring to the LISTEN command :)

[mbonneau]

This is not currently supported. It does not seem like it would be difficult to implement. The best way to do it would just be to reserve a connection for listening and not run any queries on it. Maybe add a ->listen([...array of things to listen to...]) and it would emit events as they are produced.

I don't have the time to implement this at the moment, but if someone else wants to take a look at it, that would be great.

[factormaarten]

I noticed you implemented it! Thank you so much, sorry for the late comment. I did not revisit the repo until now and somehow did not receive notifications from here. Looks awesome :)