We need to stop using Stored Procedures

The article argues that application teams should stop relying on stored procedures because modern parameterized SQL executed from the application can deliver the same performance benefits—such as plan caching and reusable query plans—without the operational complexity. For IT organizations, the strategic upside is tighter alignment between application and database logic, simpler version control and rollback paths, and fewer cross-team deployment dependencies, while DBAs shift from owning routine application SQL to coaching on query design, indexing, and performance tuning.

Hacker News3 min read
Read full article
We need to stop using Stored Procedures

Read the full story at Hacker News →