u/indy2kro

OFFSET doesn't skip rows. It scans them and throws them away. LIMIT 50 OFFSET 10000 makes the database visit 10,050 rows and discard the first 10,000. Every time. The fix everyone knows is cursors — but the gotchas around non-unique sort keys silently dropping records, unsigned cursors being an auth bypass on multi-tenant APIs, and why COUNT(*) is often slower than the actual query are the parts that actually bite you in production.

A look at how coverage metrics work in CI/CD, why they're misunderstood, and how to enforce them without incentivizing shallow tests.