Hacker News new | ask | show | jobs
by Southland 1152 days ago
I worked at a company which relied on significant use of Postgres triggers and it was not simplified in my mind due to:

- Engineers being more comfortable expressing the required business logic in the other languages they were working in then PL/pgSQL

- Challenging to write tests for the triggers

- Harder to deploy variations for testing if needed

1 comments

You can write tests using pgTAP https://pgtap.org/