#574 Measures 3: totals in the summary trees (browser, PostgreSQL, SQLite)
–
- github
- github/openchronology/timeline-app
- github/openchronology/timeline-app#574
- issue
- state:closed
Part 3 of #570. Every summary tree keeps, per node, its subtree's total of each measure beside its count. The total is one monoid (exact rational addition), computed the same way in every engine. - **Browser:** `rational-ordered-map` summaries hold totals beside `entryCount`. - **PostgreSQL:** - totals per node in a side table, `(timeline_id, node_id, measure, total mpq)`; - `avl.mjs` keeps them as it keeps counts; - forks carry them as row data; - an index-version bump rebuilds the trees. - **SQLite:** `vendor/sqlite-rational` node summaries add an `mpq` per measure, and an `index_layout` bump rebuilds them on open. - **Edits:** an edit that changes a value rewrites the nodes on its path. Other metadata edits still touch none. - **Tests:** an oracle test checks that every engine gives the same totals as summing the values. https://github.com/circagraph/timeline-app/issues/574
Related
- #570 Measures: typed quantities on moments and durations, totalled in every summary
- #579 Measures: totals in the editor's index and its overview groups (#574)
- #580 Measures: totals in the PostgreSQL moment tree and its overviews (#574)
- #581 Measures: totals in the desktop file's SQLite index (#574)
- #582 Measures: totals on summaries, values on hover cards, and plugins (#575)
- #595 Measures: running balances from changes, and one change index per timeline
- Measures: totals in the PostgreSQL moment tree and its overviews (#574)
- Merge pull request #581 from openchronology/feat/574-sqlite-totals
- Measures: totals on summaries, values on hover cards, and plugins (#575)
- Measures: totals in the desktop file's SQLite index (#574)
- Measures: totals in the editor's index and its overview groups (#574)
- Merge pull request #579 from openchronology/feat/574-browser-totals
Open #574 Measures 3: totals in the summary trees (browser, PostgreSQL, SQLite) in the timeline