News for hackers. Stuff that matters.

A comment on Securing a Postgres Database. Parent comment

Re:Securing a Postgres Database by citrin_ru on Friday April 02, 2021 @07:17PM (#26676905)
I have an impression that many developers actively avoid stored procedures, trigger or any 'complex' database features because they don't fit well into a typical CI/CD pipeline which deals only with application code.

It is quite possible to test stored procedures, it's just requires some additional work/infrastructure.

[ Parent | on HN ]
Re:Securing a Postgres Database by fmajid on Friday April 02, 2021 @11:47PM (#26678283)
It's mostly a familiarity and education problem, as well as the fact MySQL didn't have good support for this. Developers are exposed to procedural programming languages at university, but seldom to databases, let alone stored procedures. Unit tests can be written in SQL or PL/PGSQL and will typically run much faster than a CI pipeline.
[ Parent | on HN ]