The Iterator pattern

Scrolling an order history: why page numbers reread everything and repeat a row when an order arrives, how an iterator holds the position and fetches a page only when its buffer runs out, a cursor instead of an offset, iterable versus iterator and why a used-up iterator stays used up, lazy sequences and generators, what happens when you remove from a list while looping, snapshots versus locks, and when not to use it.