curious if anyone has used the pub/sub functionality of Postgres with CFML?

I use postgres with cfml, however I have never tried the pub/sub features of postgres... I do see that there are some limitations with JDBC drivers not being able to receive asynchronous notifications though so my gut feeling is that it would not work.

thanks - just starting to explore now. And yeah, I've seen some possible jdbc issues. we'll see

I'd certainly be interested in your results if you can get it to work

fwiw I"m seeing the same thing - it seems like you need to implement polling to check for notifications: https://jdbc.postgresql.org/documentation/head/listennotify.html

looks like you might have to implement something like Kafka then connect to that via coldfusion

The research i did with last years presto suggested pub/sub with postgres is more of a feature made to work with it vs being well made to do it

ahhh - good to know. I was trying to track down that preso actually, when I ran into some cfcasts issues, lol

😛

thanks! I'll check that out

and thats why i love open source 🙂