BASE 44 ORDER: Build e8_resonance_cache table with BRIN index, hash-compute, cache-check, and TTL sweep — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1102] Create e8_resonance_cache table with e8_hash BIGINT PK, query_text TEXT, llm_response JSONB, created_at TIMESTZ. Add BRIN index on created_at. Implement hash-compute + cache-check before LLM call. Add TTL expiry sweep via systemd timer every 10 minutes. MERLIN: Understood, Maker. I will create the e8_resonance_cache table with e8_hash as BIGINT PK, query_text TEXT, llm_response JSONB, and created_at TIMESTZ, plus a BRIN index on created_at. The swarm will implement hash-compute and cache-check logic before any LLM call, and set up a systemd timer to sweep expired entries every 10 minutes. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com