I have a PostgreSQL database that fires a NOTIFY mychannel
when rows in a table are inserted.
I would like to send this info out to a variety of sources (Twitter, etc) using Apache Camel.
I understand that one can use JDBC and call LISTEN mychannel
to receive those notifications, but may need to use polling.
I'm pretty new to Camel, so not sure where to start. Is this something I would do with the SQL, JDBC, or Polling Consumer connectors?
Is there a built-in method to do this in Camel efficiently?
Updating this question with a more recent answer. This camel component has been created: