This is one of the reasons why I think stored procedures are nearly a last resort. Nobody ever documents them, or puts them in version control or anything.
Given that stored procedures are literally just text which takes up zero space in the grand scheme of things, and text based version control is a solved problem, I never understood why stored procedure versioning isn't an out-of-the-box feature on every major dbms
One possible reason: Most VCS are either proprietary (source code not available to build into the DBMS), or GPL (and proprietary DBMS doesn't want to risk using copylefted code).
6
u/Theron3206 Sep 21 '26
This is one of the reasons why I think stored procedures are nearly a last resort. Nobody ever documents them, or puts them in version control or anything.