I’m working for a software company designing and implementing warehouse management systems. Currently we’re evaluating different options to write a completely new product version from scratch (also changing programming language from some old proprietary language to C#).
Actually we’re a little stuck at a decision point where to put the whole business logic into, as some of us prefer to have it inside the application layer, while others see big advantages if we place it inside the database itself (triggers, constraints, stored procedures).
Does anyone have some experience with both options or you maybe were at a similar decision point?
We’d be grateful if you could share some thoughts and experiences
Thanks and have a nice weekend!