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
Getting AI to write good SQL
331–340 of 379 posts
Re: Getting AI to write good SQL
#332For 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
Re: Getting AI to write good SQL
#333Earlier 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! "
Re: Getting AI to write good SQL
#334Earlier 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..."
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
#335Can 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.
Re: Getting AI to write good SQL
#336Earlier 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?
Re: Getting AI to write good SQL
#337Earlier 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.
Re: Getting AI to write good SQL
#338Earlier 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.
Re: Getting AI to write good SQL
#339Can 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.
Re: Getting AI to write good SQL
#340Earlier 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...
Also this is the easiest starter puzzle, once you solve it you can click through to the next ones with increasing difficulty.