←back to thread

Getting AI to write good SQL

(cloud.google.com)
478 points richards | 2 comments | | HN request time: 0.41s | source
Show context
AdrianB1 ◴[] No.44010668[source]
In real life I find using AI for SQL dangerous. It allows people that don't know what they do to write queries that can significantly impact servers. In my world databases are relatively big for most developers, but not huge.

Sometimes when I want to fine tune a query I am challenging AI to provide a better solution. I give it the already optimized query and I ask for better. I never got a better answer, sometimes because AI is hallucinating or because the changes that it proposes are not working in a way that is beneficial, it is like an idiot parrot is telling what it overheard in the brothel - good info if it is a war brothel frequented by enemy officers in 1916, but not these days.

replies(5): >>44010829 #>>44011104 #>>44011385 #>>44011554 #>>44011573 #
1. awesome_dude ◴[] No.44010829[source]
Mate, IME programmers who don't know what they are doing just do it anyways then look to blame someone/something else if things turn to custard.

AI is just increasing the frequency of things turning to custard :)

replies(1): >>44011027 #
2. HideousKojima ◴[] No.44011027[source]
AI is most effective as an accountability sink