Database Events

database-events.html

Database integration is not a straight forward task. Most of the time it's done using a script or a process that is invoked on schedule. Usually you want to do something when a data is changed. This can be done easily from the source code of the process modifying the data. However, this is not always possbile as it requires access to the source code, and skills in the technology used. This leaves us with very limited options.

In this series we discuss each method separately. We try to generalize and remain vendor neutral, however in some posts we will focus on postgresql specific functionality.

For each solution we will do a quick comparison table based on the following criteria

Criteria	description
Requires Polling
Scalable for many tables
Vendor neutral
Platform independent
Performance

1. Database events - Part 1 - Polling a table with Apache Camel
2. Database events - Part 2 - Polling an events table with apache camel
3. Database events - Part 3 - getting events using LISTEN/NOTIFY (postgresql only)