420: AI for the Code-Writing Purist: How to Use AI Without Surrendering Your Keyboard
Episode
23 min
Read time
2 min
Topics
Productivity, Relationships, Artificial Intelligence
AI-Generated Summary
Key Takeaways
- ✓Bug Investigation Partner: Configure AI with system prompts to investigate bugs by providing error messages, suspected modules, input/output data, and related code. AI builds internal theory of programs to trace issues without executing code, offering fresh perspective beyond static analysis tools.
- ✓SQL Query Optimization: Run queries with EXPLAIN ANALYZE output, provide database schema and existing indices to AI for optimization suggestions. This approach yields immediate speed improvements in 99% of cases by identifying wrong index ordering or missing indices without AI writing code directly.
- ✓Security Review Automation: Implement pre-commit hooks with security-focused system prompts expressing preferences and best practices. AI checks recent commits for vulnerabilities, semantic correctness, and adherence to standards, catching issues like misconfigured cache settings that could enable system abuse before deployment.
- ✓Documentation-Driven AI Reliability: Create comprehensive documentation blocks in each module describing purpose, data flow, performance requirements, and critical functions. After documenting 10 files manually, AI can replicate pattern across codebase with 95% accuracy, dramatically improving subsequent AI tool reliability and acquisition readiness.
What It Covers
Arvid Kahl demonstrates how developers can leverage AI tools for code investigation, security review, optimization, and documentation without letting AI write production code, maintaining control while augmenting capabilities through strategic prompting and system configuration.
Key Questions Answered
- •Bug Investigation Partner: Configure AI with system prompts to investigate bugs by providing error messages, suspected modules, input/output data, and related code. AI builds internal theory of programs to trace issues without executing code, offering fresh perspective beyond static analysis tools.
- •SQL Query Optimization: Run queries with EXPLAIN ANALYZE output, provide database schema and existing indices to AI for optimization suggestions. This approach yields immediate speed improvements in 99% of cases by identifying wrong index ordering or missing indices without AI writing code directly.
- •Security Review Automation: Implement pre-commit hooks with security-focused system prompts expressing preferences and best practices. AI checks recent commits for vulnerabilities, semantic correctness, and adherence to standards, catching issues like misconfigured cache settings that could enable system abuse before deployment.
- •Documentation-Driven AI Reliability: Create comprehensive documentation blocks in each module describing purpose, data flow, performance requirements, and critical functions. After documenting 10 files manually, AI can replicate pattern across codebase with 95% accuracy, dramatically improving subsequent AI tool reliability and acquisition readiness.
Notable Moment
Arvid deployed a homepage search feature after weeks of development, and AI security review caught a forgotten test cache setting of zero that would have allowed unlimited uncached searches, potentially saturating the entire system through automated request barrages.
Episode Transcript
Hey. It's Arvid, and this is the Bootstrap founder. I know you're out there, the developer who watches their colleagues very enthusiastically embrace cloud code and cursor codex whatever they're called having AI write entire feature sets while you still proudly type every semicolon by hand. You're the founder who sees AI generated code as a ticking time bomb, bugs, security, vulnerabilities, all all that kind of stuff. You're the software founder who believes that real code comes from human minds, not language models. This one is for you. A quick word from our sponsor, paddle.com, before I get started. I use Paddle as my merchant of record for all my SaaS businesses. They take care of all the taxes, currencies, tracking the client transactions, credit cards, all that stuff. So I could focus on building my product. They just recently released a new guide and I think you should check this one out. It's called Grow Beyond Black Friday and it contains very actionable strategies for payment conversion and billing tactics to maximize revenue and retention in the long term. It's all about using seasonal sales effectively. And if you have anything to sell, which most of us do, check out paddle.com as your payment provider. The link to the guide is in the show notes. Okay. Here's the thing. Even if you're in the AI embracing camp right now, happily letting robots write your Redux boilerplate, your React code, whatever it might be. What I'm about to share will be equally valuable for you because today I'm going to show you all the ways that you can leverage AI in your software projects without having it write a single line of production code. There is more than having AI write every single thing. The biggest breakthrough and likely what some of you already have tried, but can be done in a very particular and intentional way is having AI systems as a coding companion. Not just somebody who's writing code, but an investigator. Someone who can just be tasked with research and who reports back with insights that you can then tackle as projects in your own timeline. This is exactly how I actually got into using AI tools as coding helpers. Because back in late twenty three and early twenty four, when I was first building PodScan, AI systems just were not capable of producing reliable code. We had auto complete and that kind of stuff, and that got a little bit more magical than it used to be. But writing actual code? Yeah, no, they couldn't. So what was I using these tools for? Well, I was tasking them with individual problems and challenges, asking them to give me insights that would then allow me to write my own code, the solution for my challenges myself from those insights. So here's the kind of thing that I would ask. This function that would paste the code gives me the wrong result even though I implemented it …
Get the full transcript (4,313 words) + summary by email — free
One-time email with the complete transcript and AI summary of this episode. No account needed.
One email, no spam. We’ll also show you what SignalCast does.
You just read a 3-minute summary of a 20-minute episode.
Get The Bootstrapped Founder summarized like this every Monday — plus up to 2 more podcasts, free.
Pick Your Podcasts — FreeKeep Reading
More from The Bootstrapped Founder
439: The Increasing Risk of Building in Public
Apr 3 · 16 min
The Daily (NYT)
Can A.I. Already Do Your Job?
Feb 18
More from The Bootstrapped Founder
438: AI Liability: The Landmines Under Your SaaS
Mar 20 · 25 min
How I AI
How this visually impaired engineer uses Claude Code to make his life more accessible | Joe McCormick
Feb 16
More from The Bootstrapped Founder
We summarize every new episode. Want them in your inbox?
439: The Increasing Risk of Building in Public
438: AI Liability: The Landmines Under Your SaaS
437: Data Is the Only Moat
436: When Long-Term Investments Finally Pay Off
435: How to Actually Use Claude Code to Build Serious Software
Similar Episodes
Related episodes from other podcasts
The Daily (NYT)
Feb 18
Can A.I. Already Do Your Job?
How I AI
Feb 16
How this visually impaired engineer uses Claude Code to make his life more accessible | Joe McCormick
The Startup Ideas Podcast
Feb 11
How I use AI Marketing and Claude Code to make $$
The Startup Ideas Podcast
Feb 9
AI marketing Masterclass: From beginner to expert in 60 minutes
How I AI
Jan 26
Advanced Claude Code techniques: context loading, mermaid diagrams, stop hooks, and more | John Lindquist
Explore Related Topics
This podcast is featured in Best Startup Podcasts (2026) — ranked and reviewed with AI summaries.
Read this week's AI & Machine Learning Podcast Insights — cross-podcast analysis updated weekly.
You're clearly into The Bootstrapped Founder.
Every Monday, we deliver AI summaries of the latest episodes from The Bootstrapped Founder and 192+ other podcasts. Free for one show.
Start My Monday DigestNo credit card · Unsubscribe anytime