"Eight years of wanting, three months of building with AI" by Lalit Maganti https://lalitm.com/post/building-syntaqlite-ai/

Lots of good advice, and matches a lot of my experience.

Eight years of wanting, three months of building with AI

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.

Lalit Maganti

@nolan Interesting post. I'm going through something similar, creating something I have wanted for years because it seems like the personal cost of building it is manageable.

In my case I'm using the regular Claude Pro plan, and one reason I haven't upgraded is it forces me to slow down. (But on the flip side, token austerity means I don't ask AI to refactor things when I should.)

I want to focus on getting an LLM to improve code quality and even architecture to some degree, not write more. It seems it's possible but I haven't seen that much written about that.