Datasette adds pagination bar with row counts and navigation buttons
The new PR introduces a top‑and‑bottom pagination bar showing current rows, total rows, and back/next controls.
A pull request merged on 7 Nov 2026 adds a pagination bar to Datasette table pages that span multiple pages.
The bar appears above the table and repeats below, displaying ranges like “Rows 101–150 of 1,761” and offering a Next page button.
On pages after the first, a Back to first page button appears, preserving filters and sort while resetting pagination parameters.
The implementation uses a new ?_count=before option on the /‑/count endpoint to fetch the number of rows ahead of the cursor, improving performance from 69 ms to 3 ms on a 1 M‑row table.
Table schema sections are also collapsed into a closed‑by‑default details/summary block, reducing visual clutter.
What it means for you
The enhanced pagination gives users clearer navigation and faster page loads, especially on large datasets. For developers building open‑source tools, the changes demonstrate how modest UI tweaks and backend optimisations can improve usability without sacrificing free software principles.
Sources
- Hide your slop PR descriptions behind, Simon Willison, 9 Nov 2026
- Pagination bar showing which rows are on the current page by simonw · Pull Request #3043 · simonw/datasette · GitHub, github.com (official), 7 Nov 2026
Written automatically from the sources above, then checked by our code: every number and name must appear in them, and no sentence may copy a source. Spotted a mistake? Report it.
Which AI can you use for free today?
Every free AI model, ranked by blind human votes, with the memory and speed it needs on your own GPU.