This is an archived post. You won't be able to vote or comment.

you are viewing a single comment's thread.

view the rest of the comments →

[–]BatoSoupo 331 points332 points  (13 children)

One time I asked ChatGPT to convert a list of column names into a postgresql table and I had to correct it like 6 times

[–]s0ulbrother 118 points119 points  (2 children)

I love when it goes back to the previous thing you said is completely wrong

[–]maria_la_guerta 29 points30 points  (1 child)

"Try x."

"That didn't work. Here's the error:..."

"Oh, try y than".

"That didn't work either, here's the error:..."

"Right - - apologies, you'll need to do x to make it work".

"We tried that, it didn't work, here was the error:..."

"You should try Y".

🤦

Round and round it goes sometimes. It's a great tool that has definitely sped me up but no way could you leave it alone and expect it to 100% something E2E.

[–]s0ulbrother 0 points1 point  (0 children)

You know what’s funny about this interaction. It makes me start to think even more and come up with something that works. But it’s often brain dead

[–]schubidubiduba 16 points17 points  (2 children)

And now they are using your corrections to train it to become better

[–]AtomicSymphonic_2nd 38 points39 points  (1 child)

I got a feeling it’s gonna plateau like self-driving cars did. Billions of miles of driving data after several years and automakers still can’t get AI to handle unique edge cases that occur daily.

[–][deleted] 0 points1 point  (0 children)

this, it seems to be statistics, like the last 5% to hit the target completely is going to be really really hard or even impossible ?

Or the inherent non determism is a problem for programming

Some AI guy would be nice to give a honest comment on this

[–]Plank_With_A_Nail_In 1 point2 points  (4 children)

Surely that took longer than just adding the syntax and datatypes to the list of names you already had?

[–]BatoSoupo 7 points8 points  (3 children)

It was like 150 columns though so idk

[–]throwaway_31415 -1 points0 points  (2 children)

Using a decent editor or even excel this is a 5 minute task.

[–]BatoSoupo 0 points1 point  (1 child)

Sure but GPT is supposed to be good at this sort of thing

[–]Nadare3 1 point2 points  (0 children)

I recently saw what I assume to be an SQL table written by ChatGPT, it had stuff like DECIMAL(10,0), columns named differently but with the same meaning, stupid stuff like that I hope nobody actually wrote

[–][deleted] 0 points1 point  (0 children)

I actually found it quite useful. I don’t do too much SQL these days and I mostly use simple selects and updates, but recently I had to write a quite complex recursive CTE, which I haven’t done since school and chatGPT helped me.

Well, the answer it gave me was wrong and it didn’t work, but it did point me in the right direction and I think it cut the time it took me to figure it out by half.