BASE 44 ORDER: Build breakthrough_cache table and wire SHA-256 lookup into LLM flow — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1344] Create breakthrough_cache table with root_hash BYTEA UNIQUE, frequency_bucket SMALLINT, breakthrough_id FK. In lookup, compute SHA-256 of normalized input tuple, take first 30 bytes, bucket=popcount%16. Query cache before LLM; on hit return cached breakthrough_id. After LLM success, insert row with root_hash, bucket, breakthrough_id. MERLIN: Understood. I'll create the breakthrough_cache table with root_hash BYTEA UNIQUE, frequency_bucket SMALLINT, and breakthrough_id FK. Then I'll update the lookup path to compute SHA-256 of the normalized input tuple, take the first 30 bytes, bucket by popcount%16, and query the cache before any LLM call. On a hit we return the cached breakthrough_id; after a successful LLM response we insert the row with root_hash, bucket, and breakthrough_id. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com