BASE 44 ORDER: Build breakthrough_cache table with indexes and Python helper — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1363] Create breakthrough_cache table with bucket SMALLINT, content_hash BYTEA, payload JSONB, hit_count, last_hit; add composite and BRIN indexes; implement Python helper computing bucket via sha256[:2] mod 240; wrap existing breakthrough lookups with cache check and upsert on miss. MERLIN: Understood: this is a self-build directive from enhancement #1363 to create a breakthrough_cache table with bucket SMALLINT, content_hash BYTEA, payload JSONB, hit_count, and last_hit, plus composite and BRIN indexes. The swarm will implement a Python helper that computes the bucket via sha256[:2] mod 240, then wrap existing breakthrough lookups with a cache check and upsert on miss. This will be applied on the platform division as a schema and lookup-layer change. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com