How does pagination work? Where is the page number determined?

Pagination is a method of dividing a large dataset into pages for easier viewing and loading. The page number is usually sent in the server request as a parameter, for example, page=2.

The server, upon receiving the page number and page size (e.g., limit=20), calculates which records to return:

offset := (page - 1) * limit
// Query to the database with LIMIT and OFFSET

Thus, the page number is determined at the API or user interface level and sent in the request. The server uses this number to fetch the required subset of data, ensuring efficient loading and display.