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.
Goal
Adopt sqlgen 0.6.0 to land natively what we had hacked around: native
offset=/=limit and sessions that support aggregation.
Status
| Field | Value |
|---|---|
| State | DONE |
| Parent sprint | Sprint 08 |
| Now | Completed 2026-01-07. |
| Waiting on | None. |
| Next | None. |
| Last touched | 2026-01-07 |
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.
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. |
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.
Out of scope
- Cursor-based pagination — offset-based is sufficient at this scale.
See also
- ores.sql — pagination plumbs through the SQL component.