3 ms·
Stored procedures has some advantages (fast to debug/try out a query from your service without copy+paste all the time, etc), but also disadvantages (unreadable
by dagss 4y ago
Stored procedures has some advantages (fast to debug/try out a query from your service without copy+paste all the time, etc), but also disadvantages (unreadable git diffs, big bang rollouts on changes)
We made this tool to get the best of both worlds:
https://github.com/vippsas/sqlcode https://github.com/vippsas/sqlcode