Measures: totals in the desktop file's SQLite index (#574)
- github
- github/openchronology/timeline-app
- commit
- main
- github/athanclark
A desktop file's moment index (the `points` rational_index) keeps its measures' totals, as the browser and PostgreSQL trees do, so overview groups carry the same `totals` everywhere. - sqlite-rational (vendored, with changes not yet upstream; see vendor/README.md): rows may carry a `sums` vector of exact rationals (hidden column; canonical rationals joined by ';'), which every node totals per subtree as it totals weights, in inserts, updates, deletes and bulk builds; a summary's `sums` is its rows' vectors added. A `q_sum` aggregate adds a column exactly. An index whose shadow table predates sums keeps working without them. Its own tests cover both, and now run in CI. - native-store: each bucket's sums are its moments' values per declared measure (q_sum over metadata.measures), in name order; sparse saves recount changed times, and a change of measure names rebuilds the index. Overviews map the sums back to names, and coalesced groups add theirs. Files saved before (index layout 2) are re-indexed when opened, and whole saves remake an older index. - A Rust test checks every group's totals at four thresholds against hand sums after a whole save, sparse changes (moves, value edits, deletions, additions), a rename of measures, and reopening an older file. Co-Authored-By: Claude Opus 5.5 Claude-Session: https://claude.ai/code/session_011fFY8eruEi1xAkkMBni13B https://github.com/circagraph/timeline-app/commit/70839d059b75c5f46636419b31b75073754c7f16
Related
Open Measures: totals in the desktop file's SQLite index (#574) in the timeline