5 ms·
because a database should not hold your business logic. It should hold your data, and that it can do well. See also my other post on parent for more reasoning.
by littlecranky67 5y ago
because a database should not hold your business logic. It should hold your data, and that it can do well. See also my other post on parent for more reasoning.
- funcDropShadow 5y agoI beg to differ in many interesting cases, we put at least some parts of the business logic into the database. The table design is a direct consequence of the business logic, the same is true for constraints and triggers.
- int_19h 5y agoWhy shouldn't it? As noted above, database servers already have most of this (security) logic in them - likely tested much better than whatever you can write on top of the database yourself. And given how many apps are basically just CRUD, why reinvent the wheel every time?
- yencabulator 5y agoMostly because the tooling is so bad. Or do you have unit tests, lint, and easy version control for your stored procedures? Are they written in a way that matches at all what rest of your programming is? Can you import a randomly picked utility library?
- int_19h 5y agoThe next obvious question is, why is tooling so bad then? And would it have been so bad if we invested as much into RDBMS as we did into Node.js web-frameworks-of-the-day.
- yencabulator 5y agoWriting the next modern elegant artisanal javascript webshit is a lot easier than making a sandboxed programming environment that integrates tightly with a production quality database engine and has a good story for testing, deployment, debugging, etc.