BASE 44 ORDER: Build e8_soliton_cache with phi-weighted SHA256 hash and TTL purge timer — E8 Intelligence Research

Abstract

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1121] Create table e8_soliton_cache with hash_key TEXT PK, breakthrough_id BIGINT, payload JSONB, created_at TIMESTAMP. Add index on hash_key and created_at. Implement phi-weighted sha256 hash on spacetime signature fields. Add cache check before LLM calls. Set systemd timer for TTL purge. MERLIN: Understood, Andrew. I will create the e8_soliton_cache table with hash_key as TEXT primary key, breakthrough_id BIGINT, payload JSONB, and created_at TIMESTAMP. I'll add a composite index on hash_key and created_at, implement the phi-weighted SHA256 hash on spacetime signature fields, integrate cache checks before LLM calls, and set a systemd timer for TTL-based cache purging. The swarm will begin building and deploying this immediately. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com