Skip to content

Store register — the instruments' read list

This table is a machine input. Every location the ledger instruments (ledger-02-gate1-v7.py, ledger-02-emit-v7.py) or any brief reads has a row here, addressed by id. No instrument carries a store path or a digest as a constant (BRIEF-LEDGER-V7, R-V7-1/R-V7-2).

role ∈ main · legacy · predecessor · body-tree · export · ledger-set-root. An instrument that wants only current databases filters role = main (plus legacy where the store is a pair). A predecessor row is kept so a brief that reads one — LIFT-AUDIT-01 reads e2-rto-01 — has a canonical place to read it from, with superseded_by naming what replaced it.

~/mirror is the one path constant, by construction — every row below is relative to it and its own row is ..

A directory has no digest. body-tree and ledger-set-root rows carry — and a file count: inventing a manifest hash would be a new fact, and this brief has not measured one.

tga-data-model.md §1 keeps its prose and cites the row id per store cell. The instruments assert that §1's digest text AGREES with this table — two sources that must match beats one that can silently drift.

id store role path (under ~/mirror/) sha256[:16] bytes since superseded_by
nrt tga-nrt main tga-nrt-05/20260914T052706Z/tga-nrt.sqlite 767f89ac3afb6ffc 932,077,568 CHILD-APPEND-01 2026-09-14 —
nrt-p4 tga-nrt predecessor tga-nrt-05/20260914T031157Z/tga-nrt.sqlite bb3167d140d369c7 928,993,280 NRT-APPEND-01 2026-09-14 nrt
nrt-p3 tga-nrt predecessor tga-nrt-04/20260912T091900Z/tga-nrt.sqlite 8b84a2e98745b474 928,423,936 INGEST-02 2026-09-12 nrt-p4
nrt-p1 tga-nrt predecessor tga-nrt-03/20260911T033219Z/tga-nrt.sqlite 4190424cbe933e5a 872,943,616 VOCAB-BUILD-01 2026-09-11 nrt-p3
nrt-p2 tga-nrt predecessor e2-stores-2026-09-01/e2-nrt-01.sqlite 2eff8cadfe218c21 144,801,792 E2-BUILD-01 2026-09-01 nrt-p1
content tga-nrt-content main tga-content-v3/PARSEOPEN01-20260914T090939Z/tga-nrt-content.sqlite b93666be2931a824 6,809,022,464 PARSE-OPEN-01 2026-09-14 —
content-legacy tga-nrt-content legacy tga-content-v3/LEGAPPEND01-20260914T074832Z/tga-nrt-content-legacy.sqlite 9e92baebbda1b5f7 3,483,017,216 LEGACY-APPEND-01 v2 2026-09-14 —
content-legacy-p1 tga-nrt-content predecessor tga-content-v3/APPLYPOP02-20260907T232701Z/tga-nrt-content-legacy.sqlite 253c2bfd7b4769b4 3,483,017,216 APPLY-POP-02 2026-09-07 content-legacy
content-p6 tga-nrt-content predecessor tga-content-v3/CHILDAPPEND01-20260914T063655Z/tga-nrt-content.sqlite 2b5fda3894f6b56c 6,806,659,072 CHILD-APPEND-01 2026-09-14 content
content-p5 tga-nrt-content predecessor tga-content-v3/CPROV01-20260914T012806Z/tga-nrt-content.sqlite 233169dddbff85d2 6,799,839,232 CONTENT-PROVENANCE-01 2026-09-14 content-p6
content-p4 tga-nrt-content predecessor tga-content-v3/CAPPEND01-20260913T042812Z/tga-nrt-content.sqlite 0f68a6988bc9290d 6,794,579,968 CONTENT-APPEND-01 2026-09-13 content-p5
content-p3 tga-nrt-content predecessor tga-content-v3/ASSETTEXT01-20260911T081626Z/tga-nrt-content.sqlite 2eecdc96e4e37acf 6,791,806,976 ASSET-TEXT-BUILD-01 2026-09-11 content-p4
content-p1 tga-nrt-content predecessor tga-stores-2026-09-04/tga-nrt-content.sqlite 81af99aa1f184209 3,805,925,376 Q3-APPLY-01 2026-09-04 content-p3
content-p2 tga-nrt-content predecessor tga-stores-2026-09-03/tga-nrt-content.sqlite ABSENT CANON-01 2026-09-03 content-p1
rto tga-rto main tga-rto-01/20260915T020659Z/tga-rto.sqlite 52154a2d6efdd7bb 6,000,332,800 FIND-RTOS-01 2026-09-15 —
rto-p5 tga-rto predecessor tga-rto-01/20260914T031157Z/tga-rto.sqlite 6956114f01106a89 6,000,328,704 NRT-APPEND-01 2026-09-14 rto
rto-p4 tga-rto predecessor tga-rto-01/20260913T025348Z/tga-rto.sqlite a75c7118659e125f 5,978,304,512 LIFT-AUDIT-01 2026-09-13 rto-p5
rto-p3 tga-rto predecessor tga-rto-01/20260912T091900Z/tga-rto.sqlite 71b334e0ab7b2620 6,707,904,512 INGEST-02 2026-09-12 rto-p4
rto-p1 tga-rto predecessor tga-rto-01/v1/tga-rto.sqlite e93515bf7ed061d4 6,707,736,576 LANE-Z-02 2026-09-03 rto-p3
rto-p2 tga-rto predecessor e2-stores-2026-09-01/e2-rto-01.sqlite 04cc52b837cd0ed3 3,756,576,768 E2-BUILD-01 2026-09-01 rto-p1
scope tga-scope main tga-scope/20260912T091900Z/tga-scope.sqlite 734cfa9c3ba1230f 493,576,192 INGEST-02 2026-09-12 —
scope-p1 tga-scope predecessor tga-scope/20260911T045028Z/tga-scope.sqlite fe6f150ea8dcda0a 493,522,944 DNH-BUILD-01 2026-09-11 scope
packaging tga-nrt-packaging main tga-nrt-packaging/v1/tga-nrt-packaging.sqlite f04ff17c8e2bb640 868,450,304 Q3-APPLY-01 2026-09-04 —
history tga-history main tga-history-01/v2/tga-history-gate3-build3.sqlite df7425aed29071a7 1,848,958,976 LANE-Z-03C 2026-09-04 — read by no ledger instrument today —
cvig tga-cvig main tga-cvig/20260916T105323Z/tga-cvig.sqlite 6313f93878101ee2 267,530,240 CVIG-STORE-01 2026-09-16 —
fetch-export pith-index-01 export pith-index-01-export-2026-09-04/pith-index-01-export.sqlite 741e23c7483a56ff 5,058,232,320 FETCH-LEDGER-EXPORT-01 2026-09-04 —
assets-ed1 pith-assets-ed1 body-tree pith-assets-ed1-2026-08-28 — 846916 files ed1 capture 2026-08-28 —
content-ed1 tga-content-ed1 body-tree tga-content-ed1-2026-08-28 — 105915 files ed1 capture 2026-08-28 —
content-probe tga-content-probe body-tree tga-content-probe-2026-08-28 — 15 files ed1 probe 2026-08-28 —
unitgrid unitgrid-2026-09-03 body-tree unitgrid-2026-09-03 — 12903 files LANE-Q-02 2026-09-03 —
supplement supplement-2026-09-01 body-tree supplement-2026-09-01 — 1349 files supplement capture 2026-09-01 —
mirror-root ~/mirror ledger-set-root . — 1988966 files the glob root for tga-fetch-*/**/_LEDGER.sqlite —

Known-present controls — one per store, the expectation and where it is filed

A count is a fact about a particular store. It moves when the store moves, so it lives here with the store set rather than inside the instrument, where it would go stale on the same event. expected is asserted against the measured count AND against the cited artefact, which must carry the figure — the control keeps its discipline; only its home has changed.

store table expected cited artefact needle
tga-nrt component 126,111 outputs/nrt-append-01/NRT-APPEND-01-GATE-4-20260914T041918Z.md 126,111
tga-nrt release 103,759 outputs/child-append-01/VERDICT-CHILD-APPEND-01-GATE-4-2026-09-14.md 103,759
tga-nrt component_currency_period 61,369 outputs/nrt-append-01/VERDICT-NRT-APPEND-01-GATE-5-2026-09-14.md 61,369
tga-rto organisation 13,151 outputs/nrt-append-01/NRT-APPEND-01-GATE-4-20260914T041918Z.md 13,151
tga-rto scope_entry 6,526,345 outputs/lift-audit-01/LIFT-AUDIT-01-GATE-4-20260913T035500Z.md 6,526,345
tga-nrt-packaging packaging_unit_cell 113,982 outputs/q3-apply-01/Q3-APPLY-01-GATE-3-2026-09-04.md 113,982
tga-nrt-content (main) reference 1,324,501 outputs/parse-open-01/PARSE-OPEN-01-GATE-4-20260914T095939Z.md 1,324,501
tga-nrt-content (main) section 610,929 outputs/child-append-01/VERDICT-CHILD-APPEND-01-GATE-4-2026-09-14.md 610,929
tga-nrt-content (legacy) section 171,389 outputs/legacy-append-01/LEGACY-APPEND-01-V2-GATE-4-20260914T090149Z.md 171,389
tga-scope delivery_notification 1,975,705 outputs/ingest-02/INGEST-02-GATE-4-20260912T091900Z.md 1,975,705
tga-cvig cvig_document_provenance 575 outputs/main-02/cvig-store-01/GATE-4-REPORT.md 575
tga-cvig cvig_sheet_row 40,546 outputs/main-02/cvig-store-01/GATE-4-REPORT.md 40,546
tga-cvig cvig_page_text 55,107 outputs/main-02/cvig-store-01/GATE-4-REPORT.md 55,107
tga-history scope_entry 6,526,172 outputs/promote-02/GATE-4-history-REPORT.md 6,526,172
tga-history component 125,838 outputs/promote-02/GATE-4-history-REPORT.md 125,838

Drafted 2026-09-12T11:56:34Z by outputs/ledger/ledger-v7-register-draft-v1.py; every digest read from the file on disk.

⚠ tga-history's two controls have weaker provenance than the other thirteen, and the difference matters. The thirteen above cite the brief that measured the store — an independent witness that existed before any promotion. history had none: the register's own row recorded it as "read by no ledger instrument today". These two figures come from PROMOTE-01's census, certified against the SQLite source by PROMOTE-02 Gate 4's content fingerprints (promote-02-g3-history-fingerprints.tsv, 39ccdac754d68e6b, 24/24 IDENTICAL) and re-asserted from Postgres at Gate 5. So they are certified against the file, not witnessed by a second instrument. The next brief that reads history for its own purpose should cite itself here and retire this note (PROMOTE-02 Gate 5, 2026-09-19).

Promotion register

[2026-09-15, NAME-RETIRE-02, R-NR-4]

Runtime naming and promotion per store are CLOSED for the seven stores of record — PROMOTE-02 landed all eight SQLite stores in library on db-01.bne on 2026-09-19; PROMOTE-01 is SUPERSEDED WHOLE and is not to be run. Every live document points here rather than carrying its own note (R-NR-4). A store of record is read by the new build only through its Product-account promotion; the prototype's rto-nrt-db is frozen (R-NR-2, R-NR-3). Timing and shape for PROMOTE-01 are ruled by outputs/rulings/RULING-PROMOTE-DIRECTION-01-2026-09-16.md 5e9da62847f716ec (2026-09-16): promote now rather than at the product turn, one store per gate or per brief, counts asserted on the far side after every load.

store of record promoted? runtime name account brief
tga-nrt yes library.nrt db-01.bne (Binary Lane) PROMOTE-02
tga-nrt-content (main + legacy) yes library.content · library.content-legacy db-01.bne (Binary Lane) PROMOTE-02
tga-nrt-packaging yes library.packaging db-01.bne (Binary Lane) PROMOTE-02
tga-rto yes library.rto db-01.bne (Binary Lane) PROMOTE-02
tga-scope yes library.scope db-01.bne (Binary Lane) PROMOTE-02
tga-cvig yes library.cvig db-01.bne (Binary Lane) PROMOTE-02
tga-history yes — and still not D1's tga-history-01 (Edition 1, created 2026-08-19), which is an earlier cloud build, not this register's history store (LANE-Z-03C, 2026-09-04) library.history db-01.bne (Binary Lane) PROMOTE-02
government statistics (ABS and other external government datasets) deferred — not a TGA source; future Pith family, re-ingested with provenance when a surface needs it; prototype copy not migrated — — RULING-GOVERNMENT-STATISTICS-01

Archives

An archive is a frozen, dated copy of ~/mirror, held off the internal disk, never updated. It is not a store and no instrument reads it. It exists so that a file removed from ~/mirror by a later, ruled tidy can still be produced. A later archive is a new line and a new folder, never a change to an old one. Archives are written as bullets, never as table rows, and this section contains no pipe character anywhere: every reader of this file takes a line beginning with a pipe for a store, so a table row here would be read as one.

  • mirror-archive-2026-09-17 — taken 2026-09-17T08:40:23Z (UTC, the source manifest's end; it began 08:36:44Z) · /Volumes/LaCie 16 Tb/mirror-archive-2026-09-17/ · 1,999,861 entries (1,991,561 files, 26 symlinks, 8,274 dirs, 0 other) · 193,585,960,893 B apparent · MANIFEST-SOURCE.tsv sha256[:16] 770f83279f9b31fc · MANIFEST-ARCHIVE.tsv sha256[:16] 6a81e1c34c359639 · rows identical on relpath, kind, bytes, sha256 (MIRROR-ARCHIVE-01 Gate 4) · locked uchg, 2026-09-18T02:27:32Z · two-disk stripe (RAID 0) per Tim, 2026-09-17; not visible to macOS · times preserved to the second; sub-second dropped by the copy tool; content proved by sha256 · MIRROR-ARCHIVE-01