BASE 44 ORDER: Build breakthrough_phi_cache with composite index and LLM cache lookup — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1229] Create table breakthrough_phi_cache (id BIGSERIAL, hash_key BIGINT, payload JSONB, created_at TIMESTAMPTZ); add composite index (hash_key, created_at DESC). In Python, compute SHA-256 of title+content, fold via golden-ratio multiplication mod 2^64. Modify lookup to check cache (<5min) before LLM; insert on miss. Add systemd timer for cleanup. MERLIN: Understood. I will create the breakthrough_phi_cache table with the composite index, implement the golden-ratio folded SHA-256 key, and modify lookup to check the cache for entries under 5 minutes before calling the LLM, inserting on miss. I'll also add the systemd timer for cleanup and have the swarm execute this build now. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com