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 Alex Aquino
: > On Apr 20, 2022, at 13:43 , Alex Aquino wrote: > > > 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 wonder

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: PostgreSQL on Amazon RDS

2019-05-18 Thread Alex Aquino
Jeremy Schneider - Thanks for that psqlrc file. Pretty informative. :-) On Wed, May 8, 2019 at 11:55 AM Jeremy Schneider wrote: > On 5/6/19 23:27, Rashmi V Bharadwaj wrote: > > Is there a SQL query or a database parameter setting that I can use from > > an external application to determine if t