BASE 44 ORDER: Build breakthrough_e8_cache with composite index and LLM cache-bypass — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1158] Create table breakthrough_e8_cache with hash_key BIGINT, breakthrough_id BIGINT, payload JSONB, created_at TIMESTAMPTZ. Add composite index (hash_key, breakthrough_id). Implement SQL function computing (hashtext(title)%240)+1. Modify Python agents to check cache before LLM, insert after response. Add systemd timer for vacuum/analyze. Use psycopg2 pool. MERLIN: Understood. I will create the breakthrough_e8_cache table with the specified schema and composite index, implement the SQL hash function, and modify the Python agents to check the cache before calling the LLM and insert after responses. I will also set up the systemd timer for vacuum/analyze and switch the connection layer to a psycopg2 pool. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com