BASE 44 ORDER: Implement e8_crystal_cache table with hash/phi-mod, LLM caching, and 1h pruning timer — E8 Intelligence Research

Abstract

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1113] Add e8_crystal_cache table via migration. Modify breakthrough INSERT/UPDATE to compute hash, phi-mod bucket, store LLM result. On lookup, query cache first; populate if miss. Add systemd timer pruning entries >1h. MERLIN: Understood, Maker. I will create the e8_crystal_cache migration, modify breakthrough INSERT/UPDATE to compute hash and phi-mod bucket, store LLM results, and add cache-first lookup logic with miss population. A systemd timer will be set to prune entries older than 1 hour. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com