I really wish a function existed in PG that took some order by clause and gave a value with comparator functions... I'll hopefully write a blog post about this in the next few days. Or I'll get sidetracked writing bg info on btrees and why offset is bad and never finish
Yeah cursor based pagination is one term folks use to describe this. Using actual sql cursors for this uses more resources than the problem it's solving though
-
-
which brings you back to a client-side filter iterator, yup
-
Yeah, that's just reinventing offset :)
End of conversation
New conversation -
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.