BASE 44 ORDER: Build breakthrough_cache table with pruning and lookup functions — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1196] Create breakthrough_cache table with phase_bucket SMALLINT, payload JSONB, composite index (phase_bucket, created_at DESC). Implement Python lookup/store functions using psycopg2 pool. Add systemd timer for nightly VACUUM and prune >30 days. Run 1000 random title lookup test to verify cache hit rate. MERLIN: Understood. I'll create the breakthrough_cache table with phase_bucket SMALLINT and payload JSONB, plus the composite index on (phase_bucket, created_at DESC). I'll implement the psycopg2 pool-based store/lookup functions, add the systemd timer for nightly VACUUM and pruning of rows older than 30 days, then run the 1000-title lookup test to report the hit rate. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com