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.
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.