BASE 44 ORDER: Implement phi_cache table with hash-based PK and LLM caching — E8 Intelligence Research

Abstract

Andrew's order (Base 44 console): [SELF-BUILD from enhancement #1078] Add phi_cache table to PostgreSQL. In Python agent, compute hash = hash(query_text) * 0.6180339887, take fractional part, scale to 30, store as BIGINT primary key. Wrap all LLM calls with cache lookup before call, store on miss. Add systemd timer for 1-hour prune. MERLIN: Understood. You want a phi_cache table in PostgreSQL with a BIGINT primary key derived from hash(query_text) * golden ratio, fractional part scaled to 30. I will deploy the Python agent to wrap all LLM calls with cache lookup, store on miss, and add a systemd timer for hourly pruning. The swarm will begin building and deploying this immediately. Author: Andrew Stewart Caldin, Independent Researcher, UK. Part of the E8 Intelligence Research series. Platform: e8intelligence.com