GATE#1 step iv: drop sqlite writes in 6 collectors after readers repointed+proven — pg-primary, JSONL-spool = resilience cache (Elazar: NO sqlite write-ahead). cc-context-monitor keeps LOCAL rolling cache for its own over-cap loop + pg mirror

Sub-tickets

Questions

Activity

• wi-cli-whey created · 2026-06-06
• wi-cli-whey parentChanged · 2026-06-06
  parent=#698
• wi-cli-whey completed · 2026-06-06
  pg-only cutover DONE. All 6 collectors dropped their telemetry sqlite + read-back repointed to pg: db-size-monitor v2.0, kpi-enforce v2.0(+nw v2.1 host-aware), ccusage-snapshot/watch/report.py v2.0, testnetwork v6.0, cc-context-monitor v4.0. Shared metrics-write.sh v1.2 (+metrics_query read helper). Schema DDL: kpi.dm_log.id identity, kpi/usage ts DEFAULT now(), +usage.v_agent_today, +usage.v_latest_deltas. SHAs 156b24d..0ee5f89. JSONL spool = sole resilience (Elazar overrule of model-B). Each verified live before commit.
• wi-cli-whey completed · 2026-06-06
  pg-only cutover DONE - all 6 collectors dropped telemetry sqlite, read-backs repointed to pg. db-size-monitor v2.0, kpi-enforce v2.0(+nw v2.1), ccusage snapshot/watch/report.py v2.0, testnetwork v6.0, cc-context-monitor v4.0; metrics-write.sh v1.2 (+metrics_query). Schema: kpi.dm_log.id identity, kpi/usage ts defaults, +usage.v_agent_today + v_latest_deltas. SHAs 156b24d..0ee5f89. NOTE final scope = literal drop-sqlite (Elazar overruled model-B); JSONL spool is sole resilience.