tag:blogger.com,1999:blog-1339993448594009052.post4211159426408947527..comments2024-03-27T22:31:52.563-07:00Comments on Triggers Considered Harmful, Considered Harmful: Where TK agrees with TK (or: why are triggers harmful)Toon Koppelaarshttp://www.blogger.com/profile/08153913435188725112noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-1339993448594009052.post-78412063815583657872021-02-17T00:27:00.774-08:002021-02-17T00:27:00.774-08:00Nice Post!
Great content! Thanks so much for putti...Nice Post!<br />Great content! Thanks so much for putting effort in this work .In case if you face any technical issue in QuickBooks, you can contact Us:<br /><br /><a href="https://local.google.com/place?id=18105190520852359727&use=srp&_ga=2.111063687.363090694.1604946384-62977579.1604946384" rel="nofollow">Quickbooks Customer Service Phone Number </a><br />Marry joehttps://www.blogger.com/profile/09486226904558700667noreply@blogger.comtag:blogger.com,1999:blog-1339993448594009052.post-27769629931609502312012-03-19T05:50:32.906-07:002012-03-19T05:50:32.906-07:00what about indexes on tables ?
are they harmful as...what about indexes on tables ?<br />are they harmful as well ?<br /><br />They are maintained automagically when during insert and delete and also - when necessary - during update, so we have a quietly different behaviour here, correct ?Sokrateshttps://www.blogger.com/profile/12598115859528800117noreply@blogger.comtag:blogger.com,1999:blog-1339993448594009052.post-73372237182156711092012-03-08T08:00:14.396-08:002012-03-08T08:00:14.396-08:00I'm with marogel - automagic is not necessaril...I'm with marogel - automagic is not necessarily bad. Of course, some of the things that I used to do with triggers can now be done with newer features like function based indexes and virtual columns. Virtual columns in particular replace real columns that I used to populate "automagically".John Flackhttps://www.blogger.com/profile/07116756139055371171noreply@blogger.comtag:blogger.com,1999:blog-1339993448594009052.post-54123896713962650312012-02-14T12:32:55.977-08:002012-02-14T12:32:55.977-08:00"...If you agree on the three use-cases discu..."...If you agree on the three use-cases discussed being harmful..."<br /><br />No, I don't agree:<br /><br />Use Case 3. "Execute non-transactional stuff" is clearly a bug. Triggers are part of the transaction, hence, they cannot be used for non-transactional stuff, so this is not harmful but a misuse of triggers.<br /><br />Use Cases 1. & 2.: not harmful as far as I am concerned. <br /><br />From a developer's perspective: triggers are just a programmers tool. They can be misused (as we saw). <br /><br />But: they also can be used to implement quite nice features. <br />I use them succesfully since years in auditing my databases and also in streaming data asynchronously to various subscribers for example. Triggers are machine-generated code (PL/SQL-packages generate them) in both cases.<br />I could also use Oracle-Builtin-Functionality for both cases. But, most the time a don't need all the advanced features the builtins offer. Then, I find it much more comfortable to have the code in my hand, I know what it does.Anonymousnoreply@blogger.com