4 ms·
In what way aren't stored procedures "normal code"? Are you claiming Git can't handle SQL files? Or that they can't be tested? Or there are no debuggers or IDEs
by gaius 11y ago
In what way aren't stored procedures "normal code"? Are you claiming Git can't handle SQL files? Or that they can't be tested? Or there are no debuggers or IDEs?
Here's a clue, a serious project will go through a dozen languages before it changes its database. You can reimplement your business logic that many times, or do it once, properly.
- frik 11y agoWhat I tried to point out it complicates the schema-update step a lot. Lot's code as stored procedures was counter productive at least in my experience. Several blog posts (post mortems) mention they avoid stored procedures as much as possible. I would debate that a "serious project" changes the code language at all. Even the old rusty SAP only switched from ASM to C and ABAP and reverted their Java misadventure. And Microsoft's products are still 90+% ASM, C and C++ code