BASE 44 ORDER: Implement breakthrough_cache with BRIN index and FNV-1a hashing — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1203] Create breakthrough_cache table with BRIN index on hash_key. Implement FNV-1a hash of title+abstract, modulo 240 bucket. Add systemd timer for cleanup (access_count<2, >1h old). Modify Python agents to check cache before LLM, increment access_count on hit, store on miss. MERLIN: Understood, Andrew. I'll direct the swarm to create the breakthrough_cache table with a BRIN index on hash_key, implement FNV-1a hashing of title+abstract modulo 240 for bucket assignment, and set up a systemd timer to clean entries with access_count<2 and older than 1 hour. Python agents will be modified to check cache before LLM calls, increment access_count on hits, and store on misses. The swarm will begin implementation immediately. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com