Stable Cursor Machine
Tie-resolution architecture mapping duplicate timestamps to unique pagination cursors.
Pause
Step State
Reset
CURSOR STATE
NEXT ITERATION
1. DATASET
TIE STATE
12:00:00 | ID:101
12:00:00 | ID:102 [LAST]
12:05:00 | ID:103
2. CURSOR TOKEN
createdAt: 12:00:00
id: 102 (tie-breaker)
3. FILTER STATE
status: "ACTIVE"
limit: 10
4. QUERY BUILDER
WHERE status = "ACTIVE"
AND (
createdAt > 12:00:00
OR (t=12:00:00 AND id > 102)
)
5. NEXT PAGE
12:05:00 | ID:103
[End of Dataset]
System Inspector
Click any stage node in the diagram above to inspect how stable cursors safely prevent duplicate values during real-time database updates.