BASE 44 ORDER: Build e8_pulse_cache with SHA256 key, 5-min TTL, upsert, and cleanup timer — E8 Intelligence Research

Abstract

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1098] Create UNLOGGED table e8_pulse_cache in PostgreSQL. In Python agent, compute SHA256(breakthrough IDs + prompt) as phase_key. Before LLM call, SELECT result WHERE phase_key=$1 AND created_at > NOW()-INTERVAL '5 min'. On miss, INSERT ... ON CONFLICT DO UPDATE. Add systemd timer for DELETE every 10 min. MERLIN: Understood. I will create an unlogged PostgreSQL table `e8_pulse_cache` with columns for `phase_key` (SHA256 of breakthrough IDs + prompt), `result`, and `created_at`. The Python agent will compute the key before each LLM call, query for a recent result (within 5 minutes), and on miss perform an upsert. A systemd timer will delete stale rows every 10 minutes. The swarm will implement this immediately. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com