canonical_visibility_index.v1.json (2738B)
1 { 2 "schema_version": 1, 3 "decision_id": "radroots.storage.canonical_visibility_index.v1", 4 "status": "implemented_not_published", 5 "owners": ["radroots_storage", "radroots_storage_sqlite"], 6 "public_boundary": { 7 "maintenance": "EventStore::maintain_visibility", 8 "bounds": "VisibilityIndexBounds", 9 "progress": "VisibilityIndexProgress", 10 "unsupported_provider": "BackendUnavailable", 11 "invalid_bounds": "InvalidVisibilityIndexBounds", 12 "capacity": "SpaceInsufficient", 13 "maximum_source_rows": 64, 14 "maximum_logical_bytes": 16777216, 15 "charge": "4096 + maximum_source_rows * 128 + sum(signed_bytes * 16 + 4096)", 16 "hidden_metadata": "VisibilityEventMetadata reuses existing head and deletion parsing; it carries no application policy" 17 }, 18 "durability": { 19 "forward_runtime_version": 19, 20 "immutable_prefix": "versions 1 through 18", 21 "canonical_truth": "signed event rows remain authoritative and immutable", 22 "mutation": "combined SQL triggers atomically advance generation epoch, event last-change epoch and dirty visibility obligation", 23 "backfill": "fixed initial sequence target with durable sequence cursor", 24 "legacy_change_epoch": "zero marks source rows predating this index; the fixed initial backfill prepares them without a whole-source UPDATE or payload decode in migration", 25 "replay": "ordered last-change epoch and source-sequence cursor; updates to previously scanned rows are replayed without resetting the initial cursor", 26 "completion": "all initial rows and subsequent changed rows prepared at the transaction's active source token", 27 "transaction": "one bounded immediate transaction; cancellation or failure before commit rolls back metadata and progress", 28 "retired_source": "SourceGenerationChanged", 29 "restore": "verified whole-file replacement preserves metadata and source together, closes old handles, and requires consumer runtime invalidation separately" 30 }, 31 "semantics": [ 32 "verified unsupported heads retain suppression authority", 33 "raw events have no head or deletion authority", 34 "only visible authorized deletion requests contribute targets", 35 "same-author event and address deletion semantics reuse the reference parser", 36 "created_at is stored as ordered unsigned 8-byte big-endian metadata", 37 "missing address identifier behavior matches the reference evaluator", 38 "no partially prepared index is advertised complete" 39 ], 40 "separate_followup": "Indexed visible/status providers and bounded repeated-read qualification remain a separate checkpoint", 41 "forbidden": ["raw SQL public API", "application ranking", "second database", "hidden worker", "unbounded fallback", "protocol registry revision"] 42 }