5 ms·
> We will cover state-of-the-art [...] how we approach techniques that allows the system to offer virtually certified correct answers. I don't need AI to gener
by rectang 1y ago
> We will cover state-of-the-art [...] how we approach techniques that allows the system to offer virtually certified correct answers.
I don't need AI to generate perfect SQL, because I am never going to trust the output enough to copy/paste it — the risk of subtle semantic errors is too high, even if the code validates.
Instead, I find it helpful for AI to suggest approaches — after which I will manually craft the SQL, starting from scratch.
- hosel 1y agoReally? In my experience it’s been pretty good (using Pydantic)! I read over before I execute it, but it’s never done anything malicious.
- rectang 1y agoI don't trust myself to craft a prompt in natural language which completely specifies my intent as codified with the precision of a programming language. I also tend to turn to AI for advising me on difficult use cases, and most of the time it's for production code rather than one-offs. The easy cases, I just write myself because it's more mental effort to review code for subtle errors than it is to write it.
- deleted 1y ago[deleted]
- yahoozoo 1y agoWhat is the relevance of Pydantic with SQL?
- deleted 1y ago[deleted]
- hsbauauvhabzb 1y agoExplain that to the average manager or junior engineer, both who don’t care about your desire to build well but not fast.
- noosphr 1y ago> So now that we brought down prod for a day the new rule is no AI sql without three humans signing off on any queries.
- Closi 1y agoIf that’s the scenario, I would be asking why the testing pipeline didn’t catch this rather than why was the AI SQL wrong.
- noosphr 1y agoBecause the testing pipeline isn't the real database. Anyone that knows a database well can bring it down with a innocent looking statement that no one else will blink at.
- Closi 1y agoSure, but everyone knows humans end up bringing down the database too by writing an innocent looking test query nobody else blinks at, which is why you end up needing a testing strategy for ANY SQL before YOLO'ing into prod.
- fkyimeanit 1y agoBecause the testing pipeline was generated by AI, and code-reviewed by AI, reading a PR description generated by AI.
- dns_snek 1y agoTo offer a 3rd option - what testing pipeline? Incompetent managers aren't going to approve of developers "wasting their time" on writing high quality tests.
- rectang 1y agoIt’s not true that I want to build “well but not fast” — I’m trying to add value, and both speed and reliability matter. My productivity is high and I don’t have trouble articulating why; my approach has generally (though not universally) been well received by management and colleagues.
- paulddraper 1y agoHopefully your trust in yourself is warranted
- rectang 1y agoI embrace my fallibility, and enthusiastically pursue testing, code reviews, staging environments, and so on to minimize the mistakes that make it through to production. It seems to me that this skeptical mindset is consonant with handling AI output with care.
- auggierose 1y agoYou'd rather trust in AI than yourself?
- malthaus 1y agoin writing good sql code? i definitely would ai is not going to replace the senior sql expert with 20 years of battle experience in the short-term but support me who last dug into sql 15 years ago and needs to get a working sql query in a project. and ai usually does a better job than me copy pasting googled code in between quickly browsing through tutorials.