BASE 44 ORDER: Implement cache table, phi_bucket function, read-path caching, hourly cleanup timer — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1274] Create breakthrough_cache table with composite index. Add Python function computing phi_bucket via hash-to-log-phi-mod-40. Modify read path to check cache, insert on miss. Add systemd timer for hourly cleanup. Update frequent lookup SQL to use cache table. MERLIN: Understood. You want a full self-build enhancement: create the breakthrough_cache table with a composite index, add the phi_bucket Python function using hash-to-log-phi-mod-40, wire the read path to check cache and insert on miss, schedule hourly cleanup via systemd timer, and update the frequent lookup SQL to use the cache. The swarm will now implement these changes across the codebase and configs, then verify the schema and timer are active. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com