| From: | Philip Semanchuk <philip(at)americanefficient(dot)com> |
|---|---|
| To: | Guyren Howe <guyren(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Are stored procedures/triggers common in your industry |
| Date: | 2022-04-20 19:26:42 |
| Message-ID: | 44FA4045-816B-4400-81CE-1BA6705BC4E1@americanefficient.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Apr 20, 2022, at 3:18 PM, Guyren Howe <guyren(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2022-04-20 19:32:07 | Re: Are stored procedures/triggers common in your industry |
| Previous Message | Basques, Bob (CI-StPaul) | 2022-04-20 19:23:38 | RE: Are stored procedures/triggers common in your industry |