First thing I tell my interns: “The guys that made that database are smarter than you, they got PhD’s for the algorithms the database uses. You are going to use SQL properly, and query properly, because the database will always do it better than your python code.”
First thing I tell my interns: “The guys that made that database are smarter than you, they got PhD’s for the algorithms the database uses. You are going to use SQL properly, and query properly, because the database will always do it better than your python code.”
Job interviewer: “What’s the best sorting algorithm for {whatever}?”
Me: “The SORT BY clause in SQL.”
Nah, we’ll just SELECT * from both tables and loop through the arrays in JavaScript to associate the records.