Answers for "pagination method in sequelize"

sequelize pagination postgres

const limit = 10;
const offset = (req.body.page - 1) * limit;

const result = await Posts.findAndCountAll({
  offset: offset,
  limit: limit,
  order: [
    ['date', 'ASC']
  ]
});

Limits and Pagination in Sequelize

// Fetch 10 instances/rows
Project.findAll({ limit: 10 });

// Skip 8 instances/rows
Project.findAll({ offset: 8 });

// Skip 5 instances and fetch the 5 after that
Project.findAll({ offset: 5, limit: 5 });