I made a comment to my coworker that "databases should be as dump as possible and should do as little as possible". He disagreed and said that they should be as smart as possible.
I couldn't backup my opinion but it is just a gut feeling (experience?) that databases should be used as simply stupd data stores with zero logic or code or anything other than data.
Who is right and why?
Due to resource bottlenecks these two activities are currently closely coupled. As a result there is no clear cut answer one way or the other.
One aspect currently is a trade off between managing complexity and performance. Of course there are many other factors. Case by case basis.