How to implement database pagination

Implement database pagination by defining a Pagination struct with page and per_page fields, then using the Query extractor in your Axum handler to deserialize these values from the URL.

use axum::{extract::Query, routing::get, Router};
use serde::Deserialize;

#[derive(Deserialize)]
struct Pagination {
    page: usize,
    per_page: usize,
}

async fn list_items(pagination: Query<Pagination>) {
    let offset = (pagination.page - 1) * pagination.per_page;
    let limit = pagination.per_page;
    // Fetch items from database using offset and limit
}

let app = Router::new().route("/items", get(list_items));

Pagination breaks a large list of database records into smaller, manageable pages so users don't have to load everything at once. You define a structure for page numbers and item counts, then let your web framework automatically read those numbers from the URL. It works like a book index, letting you jump to specific sections without reading the whole book.