Handling Dynamic Filters and Pagination in Knex.js
Learn how to build flexible, secure search queries in Knex.js using conditional builders and offset pagination, including a practical example and performance trade-offs.
Loading…
ReadMeFeed / Community knowledge
#pagination
Real questions. Useful conversations. Find the people who know your stack.
nodejsServer-Side Pagination in Livewire with the WithPagination Trait
Livewire's WithPagination trait gives you server-side pagination with SPA-like updates. Here's the setup, the page-reset bug to avoid, and the payload cost to measure.
livewire
laravelStop Slicing Arrays: Paginate at the SQL Layer with Laminas Paginator's DbSelect Adapter
Fetching all rows and slicing arrays in PHP wastes memory at scale. Laminas Paginator's DbSelect adapter pushes pagination into SQL with LIMIT/OFFSET plus a COUNT query — here's how to use it, where it breaks, and how to verify it.
laminas
phpDataTables Client-Side vs Server-Side Processing: A Decision Guide
Decide between DataTables client-side and server-side processing based on dataset size and volatility, with a comparison table, a server-side implementation sketch, and a dev-tools validation checklist.
datatablesSafe Pagination with CodeIgniter’s Query Builder
Learn how to use CodeIgniter’s Query Builder to fetch paginated data while automatically escaping user input and keeping driver switches painless.
codeigniterServer-Side Pagination with the JPA Criteria API in Hibernate 5.2+ and 6.x
Implement efficient server-side pagination in Hibernate 5.2+ and 6.x using the JPA Criteria API (CriteriaBuilder/CriteriaQuery). Avoid OutOfMemoryErrors, understand the collection fetch trap (HHH000104), and verify database-level LIMIT/OFFSET generation.
hibernateFaunaDB Index‑Based Pagination: Design, Usage, and Common Pitfalls
FaunaDB’s cursor‑based pagination lets you fetch pages without offsets. Learn how to design a paginated index, run <code>Paginate</code> queries, and avoid common pitfalls like cursor size limits and non‑unique sort fields.
faunadbModeling Structured Content with Jekyll Collections: A Practical Guide
Jekyll Collections let you model structured content—like releases or products—with custom folders and permalinks. Learn how to configure them, implement pagination with jekyll-paginate-v2, and choose between Collections and Data Files.
Choosing Hibernate Pagination for Large Result Sets: Offset vs Cursor – A Practical Architecture Note
When dealing with millions of rows in Hibernate, offset‑based paging can choke performance, while cursor‑based paging offers efficient deep navigation. This guide outlines requirements, minimal designs, trust boundaries, operational checks, and failure modes for each strategy.
jeet