3 ms·
I'm all for straight up queries and understanding... even some more complex sprocs... I'm not a fan of too much logic in the dbms, since it's pretty much a lock
by tracker1 4y ago
I'm all for straight up queries and understanding... even some more complex sprocs... I'm not a fan of too much logic in the dbms, since it's pretty much a lock-in for a single vendor, limits breaking pieces out for scale and makes things generally much harder to find/understand in practice. I'm a proponent of what I like to call discoverable code structures, sprocs/functions don't lend themselves to that.
- marcus_holmes 4y agoyeah, I should have added "can be, not should be" ;) Though I have met DB Admins who insist that the only way of stopping bad data getting into the DB is to have the DB do all the data manipulation, including a lot of what we would now consider business logic
- tracker1 4y agoYeah, I've worked in environments like that... and after a few years, it takes an inordinate amount of time to add/change anything as a result.