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: please show me the database records in the order they were found COMPUTER: thats too hard. no, really, it's very hard
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"
