Implementing pagination

There are two ways that I know to implement pagination:

  • Offset-based
  • Cursor-based

In offset-based pagination, we pass in the absolute index of all the results for a search, and we only see results from then forward. It's pretty straightforward to implement with basic SQL or to use an ORM's API.

Here's an example of offset-based pagination with Sequelize.

// repos/implementations/sequelizePostRepo.ts

export class SequelizePostRepo implements IPostRepo {
  public async getPopularPosts (offset?: number): Promise<PostDetails[]> {
    const PostModel = this.models.Post;
    const detailsQuery = this.createBaseDetailsQuery();
    detailsQuery.offset = offset ? offset : detailsQuery.offset;
    detailsQuery['order'] = [
      ['points', 'DESC'],

    const posts = await PostModel.findAll(detailsQuery);
    return => PostDetailsMap.toDomain(p))

In cursor-based

Howdy 👋

This is an online wiki and book about the basics of software design and architecture with TypeScript by Khalil Stemmler, Developer Advocate @ Apollo GraphQL .

This book’s mission is to teach developers the essential skills and practices to write testable, flexible, and maintainable code.

You can read more about the learning journey in the "Software Design and Architecture Roadmap 🖼️".

Already bought it?

If you’ve already purchased the book, click here to re-send your link. You can read the online wiki or download a copy of the book in PDF, EPUB, and Kindle versions.

Want access?

You can read the intro to the book for free and visit to buy the book/wiki (it's currently on pre-sale for 33% off)! For recent updates, click here. To get an idea of my writing, read some of my best free content here and here.

Need help?

Something not working? Have a question? You can reach me on Twitter or