Exact point at which I drop out of SQL: https://pgexercises.com/questions/joins/threejoin2.html … "I mean I could do it with subqueries." "Don't use subqueries." "Ruby it is"
-
subqueries are so good, the query planner can do so many clever things with them
this is why `INNER JOIN (SELECT id FROM same_table OFFSET 5000)` is better than just using offset, too
-
-
(Actual thing that is significantly more performant if your query planner sucks (Eg MySQL))
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.