BASE 44 ORDER: Build breakthrough phase cache with hash-based partitioning and LLM integration — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1260] 1. Create table breakthrough_phase_cache(id serial PK, breakthrough_id int, phase_key int, payload jsonb, created_at timestamptz default now()). 2. Add index on (phase_key, breakthrough_id). 3. Implement hash(title+content)%240 as phase_key. 4. Add cache check/store in agent LLM call path. 5. Add systemd timer for vacuum/prune >7 days. 6. Use psycopg2 pool. MERLIN: Understood. I'll create the breakthrough_phase_cache table with the specified schema, add the composite index, implement the hash(title+content)%240 phase_key logic, wire cache check/store into the agent LLM call path, add a systemd timer for vacuum/prune of entries older than 7 days, and switch the connection layer to a psycopg2 pool. The swarm will begin with schema migration, then code integration, then timer deployment. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com