Chapter 12: Pagination and Dynamic Queries
In this chapter, we'll talk about pagination and dynamic queries in jOOQ, two topics that work hand in hand in a wide range of applications to paginate and filter lists of products, items, images, posts, articles, and so on.
In this chapter, we will be covering the following topics:
- jOOQ offset pagination
- jOOQ keyset pagination
- Writing dynamic queries
- Infinite scrolling and dynamic filters
Let's get started!
Technical requirements
The code for this chapter can be found on GitHub at https://github.com/PacktPublishing/jOOQ-Masterclass/tree/master/Chapter12.
Offset and keyset pagination
Offset and keyset pagination (or seek, as Markus Winand calls it) represent two well-known techniques for paginating ...
Get jOOQ Masterclass now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
