BASE 44 ORDER: Build breakthrough_cache with xxhash64 and 7-day pruning — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1262] Create breakthrough_cache table with hash_key unique and payload JSONB. Add xxhash64 of normalized title+content to agent read/write paths, upsert on write, check on read. Add daily systemd timer pruning entries older than 7 days. Use psycopg2 pool for connections. MERLIN: Understood. I will create the breakthrough_cache table with hash_key unique and payload JSONB, add xxhash64 of normalized title+content to agent read/write paths with upsert on write and check on read, and set up a daily systemd timer to prune entries older than 7 days. The swarm will implement this using psycopg2 connection pooling as specified. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com