Hacker News new | ask | show | jobs
by turnsout 264 days ago
This is such a weak take to read while I have Claude Code running in the background creating a new database migration for a feature we're building
3 comments

How much time to create a new database migration, like for actually typing it?
I'd estimate that using AI to implement a well-defined feature typically takes about 1.5x the time for me - and yet I still use AI extensively.

The key difference is that I can context switch. Once the AI has context and is doing its thing, I can move on to another task that's not working in the same area or project. I can post on HN. I can catch up on my Slack inbounds, or my email.

Having two tasks running at once nets a small but nice improvement in velocity. Having any tasks running while I'm doing other things effectively doubles my output.

Can't your stack do that for you?

The one I use creates the migrations, locally, for free and deterministically in about 30 seconds.

I'm using raw Postgres. I don't like a lot of dependencies or "stacks" where they don't need to be. Claude does this extremely efficiently.
You say you don't like stacks, and that you don't need them.

But you pay a subscription to run a stack of software in anothers people computer.

btw wtf is raw postgres?

Look, there's a rich spectrum of abstraction that we are lucky enough to choose from as developers. Obviously you can write a byte stream onto the disk using assembly if you want, or you can have a high-level API store data for you without knowing how or where it's going. You can call any combination of technology a "stack."

Since you asked, the level I've chosen for this project is Go and PostgreSQL via pq. There's a single level of indirection to wrap the database access in case we need to switch from Postgres for any reason, but otherwise the app interfaces directly with the database. Migrations are simple SQL files that are run as necessary as the server starts up.

This will all run on a dedicated server that is already doing other stuff. That's the full "stack" as it were.

If Claude Code can do it what do we need you for?
Someone needs to know what a "database migration" is in order to ask Claude to build one.

I think a lot of people are massively underestimating how much knowledge and skill is needed in software engineering beyond typing code into a text editor.

You know that Linus was at one point "typing code into an editor" to review other people's patches because he found it easier to catch mistakes that way.

If your field of software engineering is so simple that you can survive on code snippets stolen from other people, great. Please do not generalize that.

What simonw wrote but also someone needs to ensure the code is correct and take the blame once it fails :-P.

I think even if we ever reach actual AGI (in the far far future), we'll still want low level meatbags around to blame :-P

Someone has to come up with the idea for app, have a vision for what it needs to be, and continually push it forward without going off-course.
How do you know it did it correctly?
Get this: I read the code and understand it