This lines up with my general experience with it. It’s quite proficient at turning a decently detailed description into code if I give it the guard rails. I’ve compared it to having a junior developer at your disposal. They could do a lot of damage if they were given prod access but can come back with some surprisingly good results.

Are you at all worried about what happens if we have a generation of human junior developers who just delegate to this artificial junior developer?

I do. If too many of our apprentices don’t actually learn how to work the forge, how ready will they be to take over as masters someday themselves?

I can see how ChatGPT was useful to the grandparent today, but got very disturbed by what it might portend for tomorrow. Not because of job loss and automation, like many people worry, but because of spoiled training and practice opportunities.

I liked your take, so I’d be curious to hear what you think.

chatgpt doesn't just program, is interactive, this will make junior dev. more emphasized in their strength and not, while gaining a lot of experience

> what happens if we have a generation of human junior developers who just delegate to this artificial junior developer?

Looking forward to the Y2K levels of highly paid consulting work becoming available now you mention it

We're eventually going to have to give up on the notion that we must understand the inner workings of the things we build. That's arguably starting to happen now. Not 100% sure it's a bad thing, but it's certainly scary.

We've long since reached the point at which no one can be said to be a true polymath ( https://en.wikipedia.org/wiki/The_Last_Man_Who_Knew_Everythi... ). Having lost the ability as individuals to know something about everything, we're now losing the ability to know everything about anything.

At some point in the past it strikes me people could have made the exact same argument about any higher level language beyond assembly.

The best answer is really if you ask chatGPT "how has the forging of steel progressed since it was invented?".

To me, you are basically worried for no reason about what happens when the apprentices no longer spends their time heating and hammering iron to remove impurities and increase carbon content. There is a trade off involved here. I am sure the apprentices of old understood at a base level what was really going on in the forge better than a modern apprentice but that hardly is an argument against progress.

Wow, so, you're not a DBE or DBA but are applying indexes across a database without concern because...a computer model spat out that you should?

This is a local SQLite database into which I had slurped a load of information about git commits to do data analysis. If I'd somehow destroyed the database, I would have just created it again.

I am also not those. Is there something wrong with too many indexes, assuming memory isn't a huge constraint?

Biggest one is write overhead: indexes have to be updated every time a record is created or an indexed column is updated. This must be done within the same transaction as the create or update, so you're adding an unnecessary overhead to every single one of those ops. Now, if the data is relatively small or the use-case doesn't warrant it, it doesn't matter.

Lesser issues: additional strain on index rebuilding whenever that happens; messing with execution plans and causing the query planner to be inefficient; primary/secondary memory overhead; or if your DB engine uses locks you can run into a myriad of issues there.

I'm all for SWEs learning about databases, as I'm morally opposed to the proliferation of ORMs and the like, but I don't think ChatGPT is the right way to go about things long-term. It's similar to Googling or using StackOverflow: yes, you will find information that is relevant to what interests you at the moment, but it's soon forgotten and does nothing to help build long-term mental models.

And to be fair, ChatGPT warned me about all of the potential issues with indexes. I did actually evaluate its suggestions and decided they were probably going to be worth the potential cost; and as I've said in a sibling thread, it was just a local SQLite database that consisted of data slurped from another source; so even if I'd somehow screwed the whole thing up, I could just delete it and start over.

Can't wait for the "I don't have a driver license but GPT19 just gives me verbal instructions on how to start the car and drive it. It can't read traffic signs but it's fine I haven't killed anyone yet"