News for hackers. Stuff that matters.
Re:PostgreSQL adds support for OUT parameters in Procedures by mikepurvis on Friday October 15, 2021 @04:22PM (#28882706)
I'd be nervous about the testability/verifiability of it. I like treating the DB as infrastructure, and I get nervous when the infrastructure gets too smart.

Maybe I'm just stuck in the olden days and haven't yet embraced the brave new world where no one can run a full local instance because it depends on queues and storage backends and whatever else supplied by a cloud vendor. But even in my little world, I feel like I experience this with overly-smart Jenkins pipelines that can't really be executed except in production or an expensive-to-maintain clone of production.

Re:PostgreSQL adds support for OUT parameters in Procedures by kumarvvr on Friday October 15, 2021 @10:18PM (#28885040)
I think the sweet spot for Database smartness is ensuring data integrity, at close to domain level.

Having views instead of tables (hiding the actual implementation details), having procedures to interface with underlying tables and having procedures to ensure data integrity for incoming changes is a great use for procedures.

Too often, I see databases used as simply storage boxes, when they are capable of being much more.

Re:PostgreSQL adds support for OUT parameters in Procedures by zz865 on Friday October 15, 2021 @05:00PM (#28883082)
I think most people have seen the app server crash and burn while the data is nice and safe in the DB. Seems sketchy to merge them. But some some usage it would be simpler.