BASE 44 ORDER: Build cache table, hash root, wire pre-LLM lookup with pruning — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1336] Create breakthrough_cache table partitioned by hash modulo 240. Add pgcrypto digest to compute root_hash. Implement Python cache lookup/insert with psycopg2 pool. Add systemd timer pruning entries older than 1056 seconds. Wire into agent pre-LLM path. MERLIN: Understood. I will create the breakthrough_cache table partitioned by hash modulo 240, add pgcrypto digest for root_hash, implement psycopg2 pool-based Python cache lookup/insert, add a systemd timer to prune entries older than 1056 seconds, and wire it into the agent pre-LLM path. The swarm will now execute this build and integration. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com