Re: Are stored procedures/triggers common in your industry

2022-04-21 Thread raf
On Thu, Apr 21, 2022 at 08:42:10AM -0500, Alex Aquino wrote: > You mentioned testing, and reminds me of another benefit. Way faster, more > reliable, cheaper to test on the DB side. Testing logic in SPs or SQL is > much easier, especially when testing requires a sequence of calls for a use > c

Re: Are stored procedures/triggers common in your industry

2022-04-21 Thread Alex Aquino
You mentioned testing, and reminds me of another benefit. Way faster, more reliable, cheaper to test on the DB side. Testing logic in SPs or SQL is much easier, especially when testing requires a sequence of calls for a use case. It is easier because of the DBs support for transactions. With tr

Re: Are stored procedures/triggers common in your industry

2022-04-20 Thread raf
On Wed, Apr 20, 2022 at 12:18:23PM -0700, Guyren Howe 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

Re: Are stored procedures/triggers common in your industry

2022-04-20 Thread Mladen Gogala
On 4/20/22 15:18, Guyren Howe 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 th

Re: Are stored procedures/triggers common in your industry

2022-04-20 Thread Alex Aquino
Agree with the comment on python, et al. I meant lock in within the context of Oracle PL/SQL. Actually, the point of Postgres support for all the languages you mentioned is interesting in that such mitigates the lockin argument if the DB used is. Postgres . Another reason to use Postgres, among

Re: Are stored procedures/triggers common in your industry

2022-04-20 Thread Benedict Holland
It's a very wierd concern for me. I have never liked that justification as we convert 1:1 SAS to python. If you use Django, converting it to flask is really hard. If you use postgresql, converting it to oracle is really hard. I love stored procedures and triggers. Many of my colleagues don't under

Re: Are stored procedures/triggers common in your industry

2022-04-20 Thread Alex Aquino
Agree on the lock in comment, however, can't we say that of anything one is dependent on in the tech stack, whether that be at the java vs javascript vs python, or now aws vs azure vs gcp? Have always wondered that lock in concern seems to be only mentioned in light of dbs, but not any other piece

Re: Are stored procedures/triggers common in your industry

2022-04-20 Thread Ravi Krishna
I've really only ever worked in web development. 90+% of web developers regard doing anything at all clever in the database with suspicion. One common argument they use is that if you write your business logic in stored procedure, you are locked to that database since stored procedure languag

Re: Are stored procedures/triggers common in your industry

2022-04-20 Thread Tim Clarke
On 20/04/2022 20:26, Philip Semanchuk wrote: > 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

Re: Are stored procedures/triggers common in your industry

2022-04-20 Thread Adrian Klaver
On 4/20/22 12:18, Guyren Howe 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 tha

Re: Are stored procedures/triggers common in your industry

2022-04-20 Thread Philip Semanchuk
> On Apr 20, 2022, at 3:18 PM, Guyren Howe 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

RE: Are stored procedures/triggers common in your industry

2022-04-20 Thread Basques, Bob (CI-StPaul)
procedures/triggers common in your industry Think Before You Click: This email originated outside our organization. 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

Re: Are stored procedures/triggers common in your industry

2022-04-20 Thread Rob Sargent
On 4/20/22 13:18, Guyren Howe 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 th

Are stored procedures/triggers common in your industry

2022-04-20 Thread Guyren Howe
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.