News for hackers. Stuff that matters.
Re:Postgres 11 – A First Look by Avamander on Saturday September 22, 2018 @06:38AM (#18045423)
I've had to debug a stored procedure, they're horrible when you have to do that. Just a big headache. I literally rewrote every single one of those procedures in the software's primary language, the code can now be easily debugged, logged, replaced and read.
Re:Postgres 11 – A First Look by pmontra on Saturday September 22, 2018 @07:55AM (#18045643)
I'm not a big fan of PL/SQL. Almost nobody is, so your approach is standard.

It's ok if all accesses to the database go through the primary application. Triggers and stored procedures make more sense when a database serves multiple applications possibly in multiple languages. Think of the db as the microservice in front of the data store. Simple stored procedures are no that bad.