Story: Native pagination support
Table of Contents
This page documents a story in Sprint 08. It captures the goal, current status, acceptance criteria, and the tasks that compose it.
1. Goal
Adopt sqlgen 0.6.0 to land natively what we had hacked around: native
offset=/=limit and sessions that support aggregation.
2. Status
| Field | Value |
|---|---|
| State | DONE |
| Parent sprint | Sprint 08 |
| Now | Completed 2026-01-07. |
| Waiting on | None. |
| Next | None. |
| Last touched | 2026-01-07 |
3. Acceptance
- vcpkg sqlgen submodule updated to 0.6.0.
- Custom overlay ports for sqlgen removed.
single_connectionaggregation hack deleted.- Pagination expanded across the repositories that were stubbed without it.
4. Tasks
| Task | State | Start | End | Description |
|---|---|---|---|---|
| Adopt sqlgen 0.6.0 native offset/limit | DONE | 2026-05-19 | 2026-01-07 | Update vcpkg submodule to sqlgen 0.6.0; drop custom overlay ports and the single_connection aggregation hack; expand pagination to feature_flags, role, permission, image, tag, login_info repositories. |
5. Decisions
- Upstream-first
- we landed the offset PRs in sqlgen itself and then waited for them to reach vcpkg, rather than carrying indefinite local patches.
6. Out of scope
- Cursor-based pagination — offset-based is sufficient at this scale.
7. See also
- ores.sql — pagination plumbs through the SQL component.