>Stored Procs make everything about your standard DevOps and SDLC process harder - branching, blue green deployments and rolling back deployments. There is a n

>Stored Procs make everything about your standard DevOps and SDLC process harder - branching, blue green deployments and rolling back deployments. There is a naming/namespacing strategy incorporating a immutable version identifier that makes this easier, which I have described here: https://news.ycombinator.com/item?id=35648974 https://news.ycombinator.com/item?id=35648974 Note that this requires a strategy for cleaning up old procedures. It also is possible to individually hash each procedure, which is more sophisticated, and would allow for incremental creation of new procedures.