1,742
1,740
1,7371,7371,7361,7361,736495495
435431314314
1883d ago · 6 min read · It returned three. The integration test had seeded five suppression rows in beforeAll, called GET /api/suppressions?limit=2, and walked the cursors forward expecting all five back. The first page returned two. The second page returned one. The third ...
Join discussionFeb 13 · 7 min read · Mine all mine, I want everything! As little children, we used to go for everything, till we grew up and realized how big the universe really is. The smartest student of a small town high school may not be admitted into MIT, and even if he is, he will...
Join discussion
Feb 12 · 10 min read · Why Traditional Offset Pagination Fails at Scale Offset pagination uses LIMIT and OFFSET clauses to skip a specific number of records. A request for page 1000 with 50 items per page translates to OFFSET 49950 LIMIT 50. The database must scan through ...
Join discussionFeb 12 · 7 min read · API Response Pagination Strategies: A Modern Developer's Guide In 2026, APIs power everything from AI-driven applications to real-time collaboration tools. As datasets grow exponentially and user expectations for performance reach new heights, implem...
Join discussionFeb 10 · 2 min read · A very common way to implement pagination is the classic OFFSET-based query: SELECT * FROM videos ORDER BY views LIMIT page_number * page_size, number_of_records_in_the_page; At first glance, this looks perfectly reasonable. You ask MySQL to skip a ...
Join discussionFeb 2 · 5 min read · 📌 Features Covered Create railway bookings View bookings in browser Filter by source & destination Sort by journey date Pagination (page-wise data) Strong backend validations Proper frontend ↔ backend connectivity 📁 Folder Structure (IMPO...
Join discussionFeb 2 · 6 min read · MongoDB itself is schema-less, but Mongoose adds schema and validation support. This ensures data stored in your database follows correct format and rules. 🔹 1. Built-in Validations in Mongoose Mongoose allows adding validations directly inside sch...
Join discussionFeb 2 · 3 min read · When working with MongoDB and Mongoose, most of the time we don’t just want to fetch all documents. Instead, we want filtered results, maybe sorted in a specific way, and sometimes divided into pages for efficiency. That’s where query operators + sor...
Join discussionJan 24 · 5 min read · When building applications with scaling datasets, the choice of pagination isn't just a minor implementation detail; it is a performance-defining decision. Like many developers, I initially fell into the "good enough" trap by relying on OFFSET pagina...
Join discussion
Jan 9 · 3 min read · Efficient pagination is absolutely critical when dealing with millions of rows in PostgreSQL — especially if you care about performance, index usage, and UX for APIs or UI pages. 1. OFFSET/LIMIT Pagination (a.k.a. “Skip-Limit”) SELECT * FROM orders O...
Join discussion