News for hackers. Stuff that matters.
Re:Getting AI to write good SQL by wewewedxfgdf on Friday May 16, 2025 @08:13PM (#44010944)
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.
Re:Getting AI to write good SQL by thingsilearned on Friday May 16, 2025 @08:30PM (#44011045)
companion or replacement?
Re:Getting AI to write good SQL by Terr_ on Friday May 16, 2025 @08:55PM (#44011187)
... Or saboteur. :p
Re:Getting AI to write good SQL by tonyhart7 on Saturday May 17, 2025 @12:31AM (#44012053)
they would replace entire software department until AI make bug because endless changes into your javascript framework then they would hire human again to make fix

we literally creating solution for our own problem

Re:Getting AI to write good SQL by roflyear on Saturday May 17, 2025 @01:00PM (#44015575)
Or, just let their users deal with the bugs b/c churn will be less than the cost of developers.
Re:Getting AI to write good SQL by scottmf on Saturday May 17, 2025 @10:46PM (#44018617)
Right. Look at Electron apps. They're ubiquitous despite the poorer performance and user experience because the benefits outweigh the negatives.

Maintaining a codebase isn't going to be a thing in the future, at least not in the traditional/current sense.

Re:Getting AI to write good SQL by yujzgzc on Friday May 16, 2025 @11:27PM (#44011815)
You're absolutely right! My mistake. I'll be careful about apologizing too much in the future.
Re:Getting AI to write good SQL by DonHopkins on Saturday May 17, 2025 @04:12AM (#44012834)
You sound like a Canadian LLM!
Re:Getting AI to write good SQL by smoyer on Saturday May 17, 2025 @12:16PM (#44015299)
Eh?
Re:Getting AI to write good SQL by gregw2 on Thursday May 22, 2025 @06:29AM (#44060639)
It's only a Canadian LLM if you ask it what its favorite food is and it says "poutine".
Re:Getting AI to write good SQL by smoyer on Saturday May 24, 2025 @02:50PM (#44083042)
Or Tim Hortons?
Re:Getting AI to write good SQL by drpbl on Monday May 19, 2025 @08:46AM (#44029281)
Does the barber shave himself?
Re:Getting AI to write good SQL by paganel on Saturday May 17, 2025 @06:12AM (#44013284)
> It is absolutely the greatest golden age in programming ever

It depends, because you now have to pay in order to be able to compete against other programmers who're also using AI tools, it wasn't like that in what I'd call the true "golden age", basically the '90s - early part of the 2000s, when the internet was already a thing and one could put together something very cool with just a "basic" text editor.

Re:Getting AI to write good SQL by danieldk on Saturday May 17, 2025 @02:29PM (#44016089)
One could put something cool together without internet using Delphi. The Borland IDEs were ahead of their time - built-in debugger, profiler, and pretty good documentation. My 'internet' was the SWAG Pascal snippet collection (which could be used fully offline). Someone converted it to HTML:

http://www.retroarchive.org/swag/index.html

Re:Getting AI to write good SQL by conartist6 on Saturday May 17, 2025 @07:43AM (#44013588)
Wow yeah I'm old enough to remember when the focus wasn't on the programmers, but on the people the programs were written for.

We used to serve others, but now people are so excited about serving themselves first that there's almost no talk of service to others at all anymore

Re:Getting AI to write good SQL by theropost on Saturday May 17, 2025 @08:42AM (#44013881)
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 by Workaccount2 on Saturday May 17, 2025 @11:13AM (#44014908)
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..."

Re:Getting AI to write good SQL by redog on Saturday May 17, 2025 @12:25PM (#44015360)
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..."
Re:Getting AI to write good SQL by rad_gruchalski on Saturday May 17, 2025 @03:27PM (#44016396)
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 by gwern on Tuesday May 20, 2025 @01:47PM (#44044048)
Have you noticed the most recent one, gemini-2.5-pro-0506, suddenly being a lot more sycophantic than gemini-2.5-pro-0325? I was using it to beta-read and improve a story (https://news.ycombinator.com/item?id=43998269), and when Google flipped the switch, suddenly 2.5 was burbling to me about how wonderful and rich it was and a smashing literary success and I could've sworn I was suddenly reading 4o output. Disconcerting. And the AI Studio web interface doesn't seem to let you switch back to -0325, either... (Admittedly, it's free.)
Re:Getting AI to write good SQL by rad_gruchalski on Saturday May 17, 2025 @03:24PM (#44016378)
You must be confusing „intelligence” with „statistically most probable next word”.
Re:Getting AI to write good SQL by stirfish on Saturday May 17, 2025 @09:40PM (#44018328)
One trick I found is to tell the llm that an llm wrote the code, whether it did or not. The machine doesn't want to hurt your feelings, but loves to tear apart code it thinks it might've wrote.
Re:Getting AI to write good SQL by jghn on Saturday May 17, 2025 @09:57PM (#44018387)
I like just responding with "are you sure?" continuously. at some point you'll find it gets stuck in a local minima/maxima, and start oscillating. Then I backtrack and look at where it wound up before that. Then I take that solution and go to a fresh session.
Re:Getting AI to write good SQL by calmoo on Sunday May 18, 2025 @07:31PM (#44025093)
Isn’t this sort of what the reasoning models are doing?
Re:Getting AI to write good SQL by jghn on Monday May 19, 2025 @10:46AM (#44030479)
Except they have no concept of what "right" is, whereas I do. Once it seems to gotten itself stuck in left field I go back a few iterations and see where it was.