3 ms·
This is a better job for a tool which can run queries like this outside of a latency-sensitive environment (hadoop, presto, whatever) Actually the right tool f
by gaius 10y ago
This is a better job for a tool which can run queries like this outside of a latency-sensitive environment (hadoop, presto, whatever)
Actually the right tool for this is plain old SQL. Even with nice formatting this is probably a 10-liner at most.
If you have a computationally intensive task, it's better to perform it on those web servers, which you can scale horizontally
It's only computationally intensive if you're doing it wrong.
- module0000 10y agoSQL is the right tool for the job! I replied to tell you that fewer and fewer people think that way....which is terrifying. "Elegant" solutions are judged as such, by their ability to avoid SQL. It's not a hard language, why is everyone trying to avoid it at the expense of their applications speed and simplicity? When I post job adverts, a large portion of applicants balk at the SQL questions: "just use PDO, or ActiveRecord, or ADO, or SQLAlchemy". Which is fine, if they can explain the difference between inner, outer, left/right joins - and they can't. SQL will be the next COBOL at this rate, or at least I hope so for selfish and monetary reasons.