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"
-
-
Replying to @patio11
"The guest user is always ID 0" Seems to be a well designed application. >_>
1 reply 0 retweets 0 likes -
don't use subqueries is horrible advice.
1 reply 0 retweets 5 likes -
I made a two and half year career as a consultant by being able to hold express things with optimised subqueries s
1 reply 0 retweets 2 likes -
subqueries are so good, the query planner can do so many clever things with them
2 replies 0 retweets 2 likes -
this is why `INNER JOIN (SELECT id FROM same_table OFFSET 5000)` is better than just using offset, too
1 reply 0 retweets 0 likes
(Actual thing that is significantly more performant if your query planner sucks (Eg MySQL))
4:23 AM - 3 Jul 2016
0 replies
0 retweets
0 likes
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.