Hacker News new | ask | show | jobs
by brtkdotse 1051 days ago
Tangentially, it’s curious there hasn’t emerged A Proper Way of version controlling and deploying stored procedures outside of “stick a bunch of sql scripts in a folder in the project root”
2 comments

Is there anything wrong with that approach? It seems pretty optimal to me, since you'll probably want to commit the stored procedures together with regular code.
Not really! It’s just weird that every places I’ve worked at basically invents it from first principles rather knowing about it.
Exactly, the reason the other alternatives feel better, is not because of how they work, but because of the tooling.