FastAPI cursor based pagination example

First Check

• I added a very descriptive title to this issue.
• I used the GitHub search to find a similar issue and didn’t find it.
• I searched the FastAPI documentation, with the integrated search.
• I already searched in Google “How to X in FastAPI” and didn’t find any information.
• I already read and followed all the tutorial in the docs and didn’t find an answer.
• I already checked if it is not related to FastAPI but to Pydantic.
• I already checked if it is not related to FastAPI but to Swagger UI.
• I already checked if it is not related to FastAPI but to ReDoc.

Commit to Help

• I commit to help with one of those options 👆

Example Code

from fastapi import FastAPI

def get_all_with_pagination(*, dB: Session = Depends(database.get_db), page_number: int=1, page_size: int = 70):
  return engine_service.get_with_pagination(
 dB, page_number, page_size
)

Description

I would like to have an example of how to implement a cursor based pagination in FastAPI. Any help would be very welcome. I managed to implement offset based pagination like the one shown in the docs but I read on the internet that offset based paginations are inefficient. Then I would like to see how to do cursor based ones in FastAPI + Sqlalchemy + PostgreSQL. The frontend is using datatable.net, how to put everything together to have a full working pagination system. Thank you for your help in advance

Operating System

Linux

Operating System Details

No response

FastAPI Version

0.75.0

Python Version

3.10.4

Additional Context

No response