The latest articles on DEV Community by HIMANSHU LOHANI (@hklohani). https://dev.to/hklohani https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F717825%2F8ce6e065-e1e6-4692-83b8-5791934f90cf.jpeg https://dev.to/hklohani en HIMANSHU LOHANI Thu, 16 Apr 2026 12:51:35 +0000 https://dev.to/hklohani/why-i-built-a-sqlite-brain-for-ai-coding-and-how-it-saves-70-90-tokens-4na2 https://dev.to/hklohani/why-i-built-a-sqlite-brain-for-ai-coding-and-how-it-saves-70-90-tokens-4na2 <h2> The Problem Nobody Talks About </h2> <p>AI coding tools are incredible for the first 30 minutes. Then quality drops.</p> <p>By the time you're on your 5th file edit, Claude is:</p> <ul> <li>Forgetting your project conventions</li> <li>Breaking imports it created 10 minutes ago</li> <li>Re-asking questions you already answered</li> <li>Producing increasingly generic, copy-paste code</li> </ul> <p>This is <strong>context rot</strong> — as the context window fills with file reads, error<br> messages, and previous task artifacts, the signal-to-noise ratio collapses.</p> <h2> The Fix: A SQLite Knowledge Graph </h2> <p>I built <a href="https://github.com/shipfast-ai/shipfast" rel="noopener noreferrer">ShipFast</a> — a framework that<br> gives each task fresh context via a persistent SQLite database.</p> <h3> How It Works </h3> <p><code>npm i -g @shipfast-ai/shipfast<br> cd your-project<br> shipfast init # indexes codebase in &lt;1 second<br> </code></p> <p>Then in your AI tool:</p> <p><code>/sf-do add dark mode toggle</code></p> <p>Behind the scenes:</p> <ol> <li> <strong>Analyze</strong> — intent detection, complexity scoring (zero tokens)</li> <li> <strong>Optimize</strong> — selects which agents to skip based on brain.db learnings</li> <li> <strong>Plan</strong> — Scout researches, Architect creates task list (fresh context)</li> <li> <strong>Execute</strong> — Builder implements each task in a separate fresh context</li> <li> <strong>Verify</strong> — Critic reviews, consumer check, stub scan, build verify</li> <li> <strong>Learn</strong> — Records decisions + patterns for next time</li> </ol> <h3> The Numbers </h3> <div class="table-wrapper-paragraph"><table> <thead> <tr> <th>Session</th> <th>Without ShipFast</th> <th>With ShipFast</th> </tr> </thead> <tbody> <tr> <td>1st time</td> <td>~100K tokens</td> <td>~30K (70% saved)</td> </tr> <tr> <td>2nd time</td> <td>~100K tokens</td> <td>~15K (85% saved)</td> </tr> <tr> <td>3rd time</td> <td>~100K tokens</td> <td>~5K (95% saved)</td> </tr> </tbody> </table></div> <p>The brain gets smarter every session...</p> ai webdev productivity opensource