BASE 44 ORDER: Build breakthrough_cache table with composite index and bucket purge timer — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1181] Create breakthrough_cache table with composite index. Implement bucket_id = floor(epoch*1.32)%240. Add query_hash column. Modify agent lookup: hash normalized query, check cache, on miss run LLM, store with bucket_id. Add systemd timer purging rows older than 10 min per bucket. Use psycopg2 pool. MERLIN: Understood. I will implement the breakthrough_cache table with a composite index, add the query_hash column, and modify the agent lookup to hash normalized queries, check cache, run LLM on miss, and store with bucket_id = floor(epoch*1.32)%240. I'll also add the systemd timer to purge rows older than 10 min per bucket and wire up the psycopg2 pool. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com