fastify-knex-paginate
A module for Fastify to support Knex's query builder with paginate method
Usage/Examples
import path from 'path'
import fastify from 'fastify'
import fastifyKnex from 'fastify-knex-paginate'
const app = fastify()
app.register(fastifyKnex, {
client: 'better-sqlite3',
connection: { filename: path.resolve('./db.sqlite3') },
useNullAsDefault: true,
})
app.get('/', () => {
return await app.knex('users').paginate({
perPage: 5,
currentPage: req.query.page || 1
})
})
app.listen({ port: 8000 }, (err, address) => {
if (err) throw err
console.log(`server running on ${address}`)
})API Reference
Read more at