Can the database somehow notify the application that in one of its tables the value of a specific field has changed? Suppose there are two servers, one updates the values ​​of the tables in the database, and the second does some calculations depending on the changed value, and the servers should not interact with each other.

  • SqlServer can . - Alexander Petrov
  • one
    Decide on the database you are using and reflect this in the question tags. Such tools are not defined by SQL standards and therefore can be done in completely different ways in different DBMSs. And in some cases, even if there is no explicit means in your DBMS, with a strong desire, you can come up with something non-standard (if the DBMS supports at least some kind of communication with the outside world) - Mike
  • one
    PostgreSQL can also. - Sergey Gornostaev
  • how to notify? which app? add parts - Anatol
  • 2
    so far an ordinary trigger begs - Anatol

0