Horton

Re: Are stored procedures/triggers common in your industry

Philip Semanchuk <philip@americanefficient.com>

View thread View on postgr.es
From: Philip Semanchuk <philip@americanefficient.com>
To: Guyren Howe <guyren@gmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2022-04-20T19:26:42Z
Lists: pgsql-general 

> On Apr 20, 2022, at 3:18 PM, Guyren Howe <guyren@gmail.com> wrote:
> 
> I’ve really only ever worked in web development. 90+% of web developers regard doing anything at all clever in the database with suspicion.
> 
> I’m considering working on a book about implementing business logic in Postgres, and I’m curious about how common that actually is.
> 


We have some business logic in Postgres functions, particularly triggers. Our apps are written in Python, and we use pytest to exercise our SQL functions to ensure they're doing what we think they’re doing. It works well for us.

FWIW, we’re not a Web dev shop.

Cheers
Philip