BASE 44 ORDER: Create e8_root_cache table with TTL and daily VACUUM ANALYZE — E8 Intelligence Research

Abstract

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1085] Create `e8_root_cache` table with root_hash BIGINT PK, breakthrough_id FK, payload JSONB, created_at TIMESTAMP. Add unique index on root_hash. Modify LLM caller to hash query, check cache, else call LLM and insert. Add daily VACUUM ANALYZE and 24h TTL cron. MERLIN: Understood. I will create the `e8_root_cache` table with root_hash as BIGINT PK, breakthrough_id FK, payload JSONB, and created_at TIMESTAMP, plus a unique index on root_hash. Then I'll modify the LLM caller to hash the query, check the cache, call the LLM only on miss, and insert the result. Finally, I'll set up a daily VACUUM ANALYZE and a 24-hour TTL cron job to purge old rows. The swarm will execute these steps immediately. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com