3 ms·
Bringing more data to the app so that the app filters it instead of the DB server is always wrong. An app with such solution is a sign of mutliple issues that
by whynotmaybe 3y ago
Bringing more data to the app so that the app filters it instead of the DB server is always wrong.
An app with such solution is a sign of mutliple issues that either the DB schema is wrong, or that the devs don't know enough Sql, or both.
Sql has been there for decades, much less longer than many of the actual dev framework. PostgreSQL (and other DBMS) have also been there for decades, they have perfected the art of fetching data.
- jon-wood 3y agoNothing is ever "always wrong". It may be a sign that a little more thought can lead to a more maintainable/quick/efficient solution, but it may also be that under the circumstances an approach that would be the wrong one if applied widely actually is the correct tradeoff between those factors in this case.