BASE 44 ORDER: Build breakthrough_cache table with BRIN index and nightly purge — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1188] Create breakthrough_cache table with root_hash BIGINT UNIQUE, payload JSONB, created_at. Add BRIN index. In Python, compute SHA-256(title+content) mod 2^240, query cache before LLM, insert on miss. Add nightly purge timer for >30 days. MERLIN: Understood. I'll create the breakthrough_cache table with root_hash BIGINT UNIQUE, payload JSONB, and created_at, plus a BRIN index. The Python layer will compute SHA-256(title+content) mod 2^240, check cache before LLM calls, and insert on miss. I'll also add a nightly purge timer to remove entries older than 30 days. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com