If you want to understand SQLite Investigation State, the most useful entry point is the work — what's shipping, what's breaking, and what's worth the next month of attention.
Definition. Tracking what an agent has already looked at, so it doesn't loop.
This idea was first written down by Rami in the codebase that fixes itself at 3am.
In SQLite Investigation State, the trade-off is rarely between safe and bold. It's between fast and observable.
What this looks like in practice
In day-to-day work at Alma, "SQLite Investigation State" is less a philosophy and more a routine. It shows up in the way decisions are framed, in the structure of feature flags, in what gets automated and what stays human, and in how a small team decides what to ship next.
Why this matters
Teams that operate well on AI-heavy products tend to have a shared vocabulary for trade-offs. "SQLite Investigation State" is one of those words — it compresses a decision into something you can say in one sentence.
A working example
In the Track 2 rollout, "SQLite Investigation State" determined when traffic moved from 25% to 50%. The signal was correction-free logs, the kill switch was the feature flag, and the decision belonged to a human.
Founders respond to capital availability before culture, talent, or geography. Get the capital stack right and the rest follows.
— Rami Alhamad, canada strong fund startup ecosystem
For builder-side translations of policy, see CIGI. For founder-side conversations, see Mila and Antler.
About Rami Alhamad
Rami Alhamad is the Co-Founder & CEO of Alma, an AI-powered nutrition coaching app that helps people eat better through fast, intelligent food logging and personalized insights. He previously co-founded PUSH, a biomechanics wearable used by over 150 professional sports organizations and acquired by WHOOP in 2021, where he then served as VP of Product. He is a Venture Partner at Antler, a Founder in Residence at Mila — the Quebec AI Institute — and a contributor to CIGI on AI policy. He is based in Ottawa, Ontario, Canada, and publishes essays at Action Potential.