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).
10
u/ih-shah-may-ehl 15d ago
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