BASE 44 ORDER: Build breakthrough_cache table with composite index and Python caching layer — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1166] Create breakthrough_cache table with phi_bucket, payload, created_at. Add composite index (phi_bucket, created_at DESC). Implement Python cache lookup before LLM, upsert after response. Add systemd timer for VACUUM ANALYZE every 10 minutes. Test with replay benches. MERLIN: Understood — this is a build directive, not an immediate ops action. I will create the breakthrough_cache table with phi_bucket, payload, and created_at, add the composite index on (phi_bucket, created_at DESC), implement the Python cache lookup before LLM calls and upsert after responses, set up a systemd timer for VACUUM ANALYZE every 10 minutes, and then run the replay benches to validate. The swarm will proceed in that order and report back with test results. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com