T
Thomas Mercer-Hursh
Guest
I have always felt that the core flaw of db triggers was that it put the logic of record creation, modification, and deletion in two different places -- partly in the trigger and partly in the application code. There is nothing in either to tell you what is happening in the other one. A properly designed modern application is going to have these actions centralized in a component responsible for those actions so there is one place to check to see what is happening and one place to modify if changes are needed. DB triggers get in the way of that goal.
Continue reading...
Continue reading...