DevOps Articles

Hidden Gems: Event-Driven Change Notifications in Relational Databases

by This feature is, in fact, available in some relational databases, but not all, as it’s non-standard functionality and not part of any SQL specification. In the three examples covered in this article, this functionality is expressed via the implementation of an interface that is then registered with the JDBC driver directly.

I had the opportunity to speak with Erik Brandsberg, CTO of Heimdall Data about this, and Erik remarked that: “The PG notify interface is one of the hidden gems in PG vs. other databases.

If so, I encourage you to discuss any of the following in the comments: While EDCNs offers powerful functionality in supported relational databases, we hope that, in addition to providing some working examples, it has also been made clear that there’s a cost associated with relying on this feature and that you must give due consideration before using it.