Live data from Hacker News

Getting AI to write good SQL

cloud.google.com

331–340 of 379 posts

Re: Getting AI to write good SQL

#331

For me the flash model is way better than the pro model. I don't want to wait all the extra time to get some code back that I'm going to have to read and modify anyway. I much prefer getting a 92.5% right answer now, than 95% correct answer a minute or minutes from now.

Are those percentages real, or plucked out of the air? I find Pro's quality starkly higher

estimates my from uses. no api, just AI studio. < 100 prompts.

Re: Getting AI to write good SQL

#332

For me the flash model is way better than the pro model. I don't want to wait all the extra time to get some code back that I'm going to have to read and modify anyway. I much prefer getting a 92.5% right answer now, than 95% correct answer a minute or minutes from now.

Are those percentages real, or plucked out of the air? I find Pro's quality starkly higher

another metaphor I feel is apt. Flash is like a REPL, Pro is like a compiler.

Re: Getting AI to write good SQL

#333

Earlier quoted context omitted.

It is absolutely the greatest golden age in programming ever - all these infinitely wealthy companies spending bajillions competing on who can make the best programming companion. Apart from the apologising. It's silly when the AI apologises with ever more sincere apologies. There should be no apologies from AIs.

I wish my AI would tell me when I'm going in the wrong direction, instead of just placating my stupid request over and over until I realize.. even though it probably could have suggested a smarter direction, but instead just told me "Great idea! "

You must be confusing „intelligence” with „statistically most probable next word”.

Re: Getting AI to write good SQL

#334
post #308

Earlier quoted context omitted.

I don't know if you have used 2.5, but it is the first model to disagree with directions I have provided... "..the user suggests using XYZ to move forward, but that would be rather inefficient, perhaps the user is not totally aware of the characteristics of XYZ. We should suggest moving forward with ABC and explain why it is the better choice..."

It really gave me a lot of push back once when I wanted to use a js library over a python one for a particular project. Like I gave it my demo code in js and it basically said, "meh, cute but use this python one because ...reasons..."

Wow, you can now pay to have „engineers” being overruled by artificial „intelligence”? People who have no idea are now going to be corrected by an LLM which has no idea by design. Look, even if it gets a lot of things right it’s still trickery.

I get popcorn and wait for more work coming my way 5 years down the road. Someone will have tidy this mess up and gen-covid will have lost all ability to think on their own by then.

Re: Getting AI to write good SQL

#335
post #222

Can I just say that Google AI Studio with latest Gemini is stunningly, amazingly, game changingly impressive. It leaves Claude and ChatGPT's coding looking like they are from a different century. It's hard to believe these changes are coming in factors of weeks and months. Last month i could not believe how good Claude is. Today I'm not sure how I could continue programming without Google Gemini in my toolkit. Gemini…

I tried it out because of your comment and the very first prompt Gemini 2.5 Pro hallucinated a non-existant plugin including detailed usage instructions. Not really my idea of good.

Same thing, I thought I would give it a shot and it got the first solution so wrong in a simple nextjs typescript project I laughed out. It was fast but incorrect.

Re: Getting AI to write good SQL

#336

Earlier quoted context omitted.

I’ve yet to see any llm proselytizers acknowledge this glaring fact: Each new release is “game changing”. The implication being the last release y’all said was “game changing” is now “from a different century”. Do you see it? For this to be an accurate and true assessment means you were wrong both before and wrong now.

I'm not an LLM proselytiser but this makes no sense? It would almost make sense if someone were claiming there are only two possible games, the old one and the new one, and never any more. Who claims that?

Parent is implying that we're still playing the same game.

Re: Getting AI to write good SQL

#337
post #315

Earlier quoted context omitted.

So glad we're pinning the success and learning of new technology on random anecdotes. Do pro AI people not see how untenable it is where everything is a rumor?

It is only a rumor to people who refuse to put in effort.

I'd rather put my effort into developing my own skills, not hand-holding a hallucinating robot.

Re: Getting AI to write good SQL

#338

Earlier quoted context omitted.

I'm not an LLM proselytiser but this makes no sense? It would almost make sense if someone were claiming there are only two possible games, the old one and the new one, and never any more. Who claims that?

Parent is implying that we're still playing the same game.

Is "game-changing" supposed to imply changing the game to a completely different one? Like, is the metaphor that we were playing soccer, and then we switched to paintball or basketball or something? I always understood it to mean a big change within the same game - like we’re still playing soccer, but because of a goal or a shift, the team that was on defense now has to go on offense...

Re: Getting AI to write good SQL

#339

Can I just say that Google AI Studio with latest Gemini is stunningly, amazingly, game changingly impressive. It leaves Claude and ChatGPT's coding looking like they are from a different century. It's hard to believe these changes are coming in factors of weeks and months. Last month i could not believe how good Claude is. Today I'm not sure how I could continue programming without Google Gemini in my toolkit. Gemini…

I’ve yet to see any llm proselytizers acknowledge this glaring fact: Each new release is “game changing”. The implication being the last release y’all said was “game changing” is now “from a different century”. Do you see it? For this to be an accurate and true assessment means you were wrong both before and wrong now.

It is just how fast this field advances compared to all the other things we've seen before. Human language doesn't have better words to describe this unusual phenomenon, so we resort to "game-changing".

Re: Getting AI to write good SQL

#340
post #101

Earlier quoted context omitted.

Regex, especially non standard (and non regular) extensions can be pretty tricky to grok. http://alf.nu/RegexGolf?world=regex&level=r00

/foo/ took me 25.75 seconds, including learning how the website worked. I actually solved it in ~15 seconds, but I hadn't realized I got the correct answer becuase it was far too simple. This website is much better https://regexcrossword.com/challenges/experienced/puzzles/e9...

Great, except you misunderstood the problem and wrote the exact opposite solution here.

Also this is the easiest starter puzzle, once you solve it you can click through to the next ones with increasing difficulty.

Post reply on HN