GeistHaus
log in · sign up

Eight years of wanting, three months of building with AI

lalitm.com

For eight years, I’ve wanted a high-quality set of devtools for working with SQLite. Given how important SQLite is to the industry1, I’ve long been puzzled that no one has invested in building a really good developer experience for it2. A couple of weeks ago, after ~250 hours of effort over three months3 on evenings, weekends, and vacation days, I finally released syntaqlite (GitHub), fulfilling this long-held wish. And I believe the main reason this happened was because of AI coding agents4. Of course, there’s no shortage of posts claiming that AI one-shot their project or pushing back and declaring that AI is all slop. I’m going to take a very different approach and, instead, systematically break down my experience building syntaqlite with AI, both where it helped and where it was detrimental. I’ll do this while contextualizing the project and my background so you can independently assess how generalizable this experience was. And whenever I make a claim, I’ll try to back it up with evidence from my project journal, coding transcripts, or commit history5.

10 pages link to this URL
Coding with AI: productivity without pride or joy

I just finished my most productive quarter in a long time, made possible by Claude Code, and there are two conflicting feelings that I want to talk about.

0 inbound links en freelancedeveloperswiftobjective-cdjangopythoniPhoneiPadiOSmacOSAppledevelopmentusabilitydesigncsshtmljavascripttypescriptreviewfull-stackopen source
Simon Willison on tools

61 posts tagged ‘tools’. Small tools I have built, many of which are hosted on my tools.simonwillison.net GitHub Pages site backed by my simonw/tools repository.

0 inbound links website en generative-ai 1785ai 2016llms 1751ai-assisted-programming 381claude 275vibe-coding 90projects 526anthropic 282prompt-to-app 39claude-artifacts 36
Simon Willison on agentic-engineering

50 posts tagged ‘agentic-engineering’. Using coding agents for professional software development. I've written a lot more about this under my broader tag ai-assisted-programming.

0 inbound links website en ai-assisted-programmingai 2016llms 1751generative-ai 1785coding-agents 201ai-assisted-programming 381vibe-coding 90claude-code 112november-2025-inflection 14parallel-agents 16definitions 53
Simon Willison on ai-assisted-programming

381 posts tagged ‘ai-assisted-programming’. Using AI tools such as Large Language Models to help write code. Vibe coding is the less responsible subset of this. See Here’s how I use LLMs to help me write…

0 inbound links website en Vibe codingai 2016llms 1751generative-ai 1785coding-agents 201claude 275anthropic 282claude-code 112projects 526vibe-coding 90openai 418
Simon Willison on vibe-coding

90 posts tagged ‘vibe-coding’. As defined here - not the same thing as AI-assisted programming, though there's some overlap.

0 inbound links website en AI-assisted programmingai 2016generative-ai 1785llms 1751ai-assisted-programming 381coding-agents 201tools 61claude 275claude-code 112definitions 53agentic-engineering 50
Notes from April 2026

This April, I offer you a feeble defense of GitHub's poor uptime, a new release of a weirdo JavaScript library, and a flurry of links.

0 inbound links article en CC BY-NC 4.0