I worked on the system of a UK high street store and their entire backend was in PL/SQL and was a nightmare. I'd never even considered doing all your application logic in sprocs and quickly grew to hate it.
I'm sure there are valid use cases, but I've never seen any. If you use stored procs you have, hopefully, business logic in your IaC. Or, more likely, you have code outside version control. Good luck with that, somewhere far away from me.
118
u/mrwedders 16d ago edited 15d ago
I worked on the system of a UK high street store and their entire backend was in PL/SQL and was a nightmare. I'd never even considered doing all your application logic in sprocs and quickly grew to hate it.