Do you still use store procedures?

Do you still use store procedures?(old.reddit.com)

2 points by tianzhou 1 year ago | 9 comments

illuminant 1 year ago |

"I hates them!"

I guess they are necessary in some edge cases, or hack jobs, or there may even be strategy for building logic from the DB out. However as a dev I cannot comprehend why anyone wouldn't just solve the problem in code...

gregjor 1 year ago | |

You have not worked with enterprise systems, I gather. Putting business logic in the database engine makes sense sometimes for performance reasons. Even better, with stored procedures core business logic gets written once, not multiple times in different client applications implemented in different languages.

illuminant 1 year ago | | |

I solve these very problems in the API stack. I cannot speak to raw performance at scale if that's you're thing, though I have long since solved the feature logic lifecycle, and it does not (generally) need this.

I would use UUID related stored procedures, for converting between forms, allowing binary IDs, uuid-form, and base32. Utilities I get. Logic override and transformation I do not. If it came to that, it's a legacy hack or you're doing it wrong.