Excellent point on consistency and that quote @sam_ferree
!
The point I have made is referring to the benefits in an exact comparison of this cursor-based approach with the traditional SQL approach to this situation.
I've been a professional C, Perl, PHP and Python developer.
I'm an ex-sysadmin from the late 20th century.
These days I do more Javascript and CSS and whatnot, and promote UX and accessibility.
This is a neat trick when Id’s are incrementing integers, and maybe that’s not a base thing to do in some cases. But ahem:
“ insertions and deletes may happen meanwhile and we don’t outdated data!”
(Laughs in eventually consistent, highly indexed query models)
Consistency is an illusion. Strong Consistency doubly so.
Excellent point on consistency and that quote @sam_ferree !
The point I have made is referring to the benefits in an exact comparison of this cursor-based approach with the traditional SQL approach to this situation.
Would you suggest anything different here?
Nope paging by ID is pretty nifty in this use-case
Is it lunch time already?