What is the correct way to listen to the database?

Question

Python

There is a MSSQL database, there is a flask controller that communicates with the database and gives values ​​to the script on the site. At the moment, I pull the ajax controller periodically and display data, but I need to make the script output data only when something has changed in the database. How to implement it correctly?

Answer 1

For MS SQL via ServiceBroker - SqlDependency. There is actually a ready implementation, but for C#
https://github.com/dyatchenko/ServiceBrokerListener

Answer 2

As an option, contact the controller using Ajax, collect data, and then check in js if the data has changed and display them