Why OFFSET Failed Us: Implementing Keyset Pagination End‑to‑End with PostgreSQL, Drizzle, tRPC, and Next.js 16

The day we crossed the hundred‑thousand‑row mark was the day the cracks began to show. Our once‑snappy feed—built on a blissfully simple LIMIT … OFFSET … query—started behaving erratically. As new rows were inserted faster than our users could scroll...