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.
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.