javascript - Any Express + SQLite Pagination plugin? -
i've been looking (on npm) pagination plugins sqlite , express, since have app lists items using plugins, did not find anything. if knows express plugin works sqlite, appreciate it.
pagination doesn't require particular library, use offsets , limits in database queries.
select * items limit 25
the above query first 25 records items
table.
select * items offset 50 limit 25
the above query start @ 50th record, 25 more records after that.
that basis pagination. supply offset pagenumber * pagesize
, limit pagesize
.
Comments
Post a Comment