Triggers: reading other opinions
April 21, 2023PGSQL Phriday PostgreSQL
This small post is about PGSQL Phriday #007, the “trigger” PGSQL Friday. I’m very happy that this challenge “triggered” so many discussions that a French friend of mine asked what was all this trend for blog posts about triggers!
Why is this fanfare about triggers recently all around?— Flavio Henrique Araque Gurgel (@fhagur) April 12, 2023
Databases already have a handful of people talking bs than we have a new one?
(Anyway you're living in the edge there 🤣)
Let’s look at the points of view I noticed:
- Ryan Booz explained his Love/Hate Relationship with triggers.
- Michael Christofides explains how Postgres does use triggers internally and how
explainwill give you how much time your query spent on triggers
- Hari Kiran gave a list of best practicies related to triggers
- dian m fay explains that “triggers are the acme of database programming”
- I explained why I’m relunctant to let developers even know triggers exist
I think we had a fun discussing that SQL feature. It was great to have other points of view! If I missed your blogpost on that topic, I apologize and I hope you won’t take it against me. I hope you had fun too adn I hope I’ll read your point of view on the next PGSQL Phriday event!