Q: What is the difference between offset-based and cursor-based pagination in FastAPI?

A: Offset-based pagination uses LIMIT and OFFSET, making it simple to implement but slower for large datasets.

Cursor-based pagination uses a unique key (like an ID or timestamp) to fetch the next set of results, offering better performance and stability with frequently changing data.