Table listener for new entries inserted


#1

Greetings Team,

I currently have a Scala application (with Java JDBC connector ) that queries SQL Server database table every minute for new entries inserted, then it does processing.

Is there a scala tool or library that I can use to listen for new entries inserted into the SQL Server Database table? I believe this new approach of listening to a table will give high efficiency.

I tried using Slick with akka streams to stream data from the table but I didn’t know to configure it to listen for new entries on the table.

Database - SQL Server Database
Connection tool - Java JDBC

Kind Regards,


(Johan Andrén) #2

Seems like there is some support to notify a message broker on change, but it doesn’t seem trivial:


#3

@johanandren Thanks so much for the feedback. I do appreciate you sharing the link.