In this essay, the author reflects on the three-month journey of building syntaqlite, a high-fidelity developer toolset for SQLite, using AI coding agents. After eight years of wanting better SQLite tools, the author utilized AI to overcome procrastination and accelerate implementation, even managing complex tasks like parser extraction and documentation. However, the experience also revealed significant pitfalls, including the "vibe-coding" trap, a loss of mental connection to the codebase, and the tendency to defer critical architectural decisions. Ultimately, the author concludes that while AI is an incredible force multiplier for writing code, it remains a dangerous substitute for high-level software design and architectural thinking.
>"Several times during the project, I lost my mental model of the codebase31. Not the overall architecture or how things fitted together. But the day-to-day details of what lived where, which functions called which, the small decisions that accumulate into a working system. When that happened, surprising issues would appear and I’d find myself at a total loss to understand what was going wrong. I hated that feeling."
>"Several times during the project, I lost my mental model of the codebase31. Not the overall architecture or how things fitted together. But the day-to-day details of what lived where, which functions called which, the small decisions that accumulate into a working system. When that happened, surprising issues would appear and I’d find myself at a total loss to understand what was going wrong. I hated that feeling."
This article presents findings from a survey of over 900 software engineers regarding their use of AI tools. Key findings include the dominance of Claude Code, the mainstream adoption of AI in software engineering (95% weekly usage), the increasing use of AI agents (especially among staff+ engineers), and the influence of company size on tool choice. The survey also reveals which tools engineers love, with Claude Code being particularly favored, and provides demographic information about the respondents. A longer, 35-page report with additional details is available for full subscribers.
