Is it possible to have a auto-tracking event or something similar to track the database when it changes?
For an example:
If the database gets a new insert value from another application that I currently have: then
My other application will notice it and fetch that data instead of getting the whole table each time.
Currently I have a loop that just gets the whole table each second. But I need to fetch the last change of the database. Is this possible or do I have to use a trigger in the database? Because I need to fix this without the use of a trigger.
(I only need the new change from the table, inserts, deletion & updates)