How to pass pagination parameters: page+size or offset+limit or from-to?

The choice of pagination parameter method depends on the context and API requirements, but the main options are:

• page + size — specify the page number and page size. Convenient for user interfaces where page numbering is important.
• offset + limit — specify the offset from the start and the number of items. Often used in SQL queries and APIs where precise data slicing is needed.
• from-to — specify start and end indices or timestamps.

Recommendations:

• If simplicity for the client and clear navigation are important — prefer page and size.
• If flexible selection of arbitrary ranges is needed — use offset and limit.
• from-to is suitable for time ranges or when data is time-ordered.

For example, REST APIs often use page and size:

GET /items?page=2&size=20

And SQL queries:

SELECT * FROM items ORDER BY id LIMIT 20 OFFSET 40;

Also consider performance and ease of implementation on the server.