Can you keep an open mind? We’ve used stored procedures for years. It has worked wonderfully for creating a single source and producer of truth for business data. Instead of potentially having business logic across multiple repos and deployments, everything exists in one place, with absolute unquestionable authority.
It’s not difficult to debug at all, you might just be unskilled.
> It’s not difficult to debug at all, you might just be unskilled.
I agree with your larger point but this seems too harsh: it’s definitely harder to debug simply because, as with microservices, understanding how the app is functioning now requires you to understand different code in multiple languages and locations, you’re highly likely to hit non-portable behavior across databases for authoring and debugging, and you’re never going to get a debugger with the whole flow in context.
That doesn’t mean there aren’t benefits as well and it could be especially useful as a way to force distinctions about contracts for common operations, but I wouldn’t say it’s right for all or even most projects. The sweet spot is going to vary widely.
The tradeoff seems to be „ability to deploy working software without reliance on single central authority”.
You may get rid of several smaller bottlenecks this way, introducing an enormous, all-encompassing one.
Or am I wrong?
It’s not difficult to debug at all, you might just be unskilled.