BASE 44 ORDER: Build breakthrough_facet_cache with 28-shard hashing and lookup decorator — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1317] Create table breakthrough_facet_cache (facet_id SMALLINT, facet_hash BIGINT, breakthrough_id BIGINT, PRIMARY KEY(facet_id, facet_hash)). Implement 28-shard hashing on insert/update. Add lookup function with GROUP BY HAVING COUNT>=3. Wrap query path with decorator. Test on replay benches. MERLIN: Understood — you want a new cache table for breakthrough facets with 28-shard hashing on writes, a GROUP BY HAVING COUNT>=3 lookup, and a decorator wrapping the query path. I'll have the swarm create the schema, implement the sharded insert/update logic, add the lookup function, and wire the decorator. Then we'll run it against the replay benches to verify correctness and performance.

Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com