2 ms·
The thing that makes me nervous about having that sort of business logic in the database is two-fold: first, finding people that can write good, clean SQL and d
by angersock 12y ago
The thing that makes me nervous about having that sort of business logic in the database is two-fold: first, finding people that can write good, clean SQL and document it so others can use it can be tricky; second, changing that logic means, effectively, more migrations.
The model of a SQL DB as dumb storage, while hardly making good use of all the (awesome!) functionality of query languages, seems to make it easier in production and in hiring.
That said, it is downright comical just how much mileage you can get from using functions or optimized queries instead of hoisting all that data up into the application layer and doing the work there.