ME: please show me the database records in the order they were found COMPUTER: thats too hard. no, really, it's very hard
Numbered pagination has unfortunate consequences for scaling. There are alternatives, but it's more complex than you might imagine, and we need better tooling support. Thoughts on Arbitrary Pagination: https://blog.seantheprogrammer.com/thoughts-on-arbitrary-pagination …
-
-
-
ME: "SQL is a declarative language that separates you from having to understand how your query is actually executed" COMPUTER: "You need to know the ins and outs of obscure data structures to understand the performance implications of this query"
End of conversation
New conversation -
-
-
For you tuple example, couldn't you just swap the order of the columns? Let's say you have this ordering, but you want to reverse the order of column 2: `(a1, a2, a3) < (b1, b2, b3)` You would do: `(a1, b2, a3) < (b1, a2, b3)`
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Another added benefit is that you don't have to invalidate http cache of *all* pages whenever you push one element and offset everything by one. All previously generated pages remain valid.
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.