BASE 44 ORDER: Build e8_memory_cache table with phi-modulated hash decorator & 1-hour prune timer — E8 Intelligence Research

Abstract

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1073] Create `e8_memory_cache` table with hash index. Implement phi-modulated hash in Python decorator. Wrap breakthrough queries. Add systemd timer for 1-hour prune. Test with EXPLAIN ANALYZE before/after. MERLIN: Understood, Andrew. This is a platform directive to build a new `e8_memory_cache` table with a hash index, implement a phi-modulated hash in a Python decorator, wrap breakthrough queries, and add a systemd timer for hourly pruning. The swarm will now execute this self-build enhancement #1073, including before/after EXPLAIN ANALYZE tests. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com