BASE 44 ORDER: Build breakthrough_cache table and integrate cache-first lookup — E8 Intelligence Research

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1190] Create breakthrough_cache table with hash_key BIGINT PK, content_hash TEXT, payload JSONB, created_at TIMESTAMPTZ. Add Python function to normalize content, compute blake2b 8-byte hash, upsert on miss. Modify lookup to check cache first, then main table. Add systemd timer for VACUUM ANALYZE weekly. MERLIN: Understood. I will create the breakthrough_cache table with the specified schema, add the Python normalization and blake2b 8-byte hash function, implement upsert-on-miss logic, modify the lookup to check cache first, and set up a weekly VACUUM ANALYZE systemd timer. The swarm will execute this build now and report back when done. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com