How to implement page-by-page (by 5 rows) paging of a table on an HTML page?

Question

Flask

On my main.html page, the database is displayed in the form of a table, there are 3 buttons (add\remove\edit rows)
It is necessary to implement pagination of the table, WITHOUT USING PHP
Here is the code for the Users table

db=SQLAlchemy() 

class User(UserMixin,db.Model):
  __tablename__='users'
  
  id = db.Column(db.Integer, primary_key=True,autoincrement=True)
  name = db.Column(db.String, unique=True)
  password=db.Column(db.String)

  def __init__(self, name, password):
    self.name=name
    self.password=password

Answer 1

datatables flips only on the way
is configured smartly

Answer 2

When requesting data from the database, do offset and limit manually, or using flask_sqlalchemy.
Here is an example .