BASE 44 ORDER: Build soliton_cache table, add LLM cache logic, schedule vacuum timer — E8 Intelligence Research

Abstract

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1116] CREATE TABLE soliton_cache (hash_key BIGINT, frequency_bucket INT, breakthrough_id BIGINT, payload JSONB, created_at TIMESTAMP); CREATE INDEX idx_soliton ON soliton_cache (frequency_bucket, hash_key); Add hash-compute + cache-check logic before LLM call in agent; store on response; add systemd timer for vacuum/prune every 10min. MERLIN: Andrew, I understand you want me to create the `soliton_cache` table with the specified schema and index, then add hash-compute and cache-check logic before any LLM call in the agent, storing the response on cache miss. Finally, I'll set up a systemd timer to vacuum and prune the table every 10 minutes. The swarm will execute these steps immediately. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com