I should add that the reason he raised it was being literally scared about the future. And not just for himself, the future of work is suddenly becoming apparent to him. Regards Greg Dr Greg Low SQL Down Under Pty Ltd +61 419201410 ________________________________ From: David Connors via ozdotnet <ozdotnet@ozdotnet.com> Sent: Tuesday, July 30, 2024 5:59:37 PM To: ozDotNet <ozdotnet@ozdotnet.com> Cc: David Connors <david@connors.com> Subject: Re: AI Doesn't surprise me. We recently bought a new house and I was trying to make sense of all of the town plan documents during the settlement period. I just uploaded it all to ChatGPT and asked for an explanation of everything including impacts of easements etc. I sent the chat to my town planner and he was pretty shocked at how good it was. It is not going to delete professions but unless you're onboard with it you won't be able to meet the performance expectations of your customers / employers. On Tue, 30 Jul 2024 at 16:55, Dr Greg Low <greg@sqldownunder.com<mailto:greg@sqldownunder.com>> wrote: Was at an eye specialist this morning for a check-up. When we were finished, he wanted to talk about AI. He showed me a system they've started using. It combines input from around six separate technical systems that they use, reads all of the patient history, clinical notes, and compares the captured images across all the years I've been to see him. As he writes his clinical notes in for the day, it wrote a summary of unbelievably high quality. He told me how it was way better than anything he could ever do, particularly the way it reviewed everything from the past and compared it (in detail) to the current. He was genuinely concerned about what sort of job he's going to have in future. It's not replacing him yet, but it's completely changed his ability to work at a much higher level. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile SQL Down Under | Web: https://sqldownunder.com<https://urldefense.proofpoint.com/v2/url?u=https-3A__sqldownunder.com_&d=DwMFAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc&m=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3&s=o3oFliHztOF8D9Nbqaa7KQdqC-zkQNXWl4IqnEG58Wc&e=> | About Greg: https://about.me/greg.low<https://urldefense.proofpoint.com/v2/url?u=https-3A__about.me_greg.low&d=DwMFAg&c=euGZstcaTDllvimEN8b7jXrwqOf-v5A_CdpgnVfiiMM&r=2rgtwrXggQFZiZbisdwDooYFalucb-vLhjG0McaanBZKn0UVuognuHqfHnjp2AVc&m=I23jyX4AKIv9q2x7A3CQAer9PGCjq8R6DwW7BE1IAhZ1JbigKMrMPRCjs6AqW7h3&s=NsAibgiqfCxsyc8m2DBKogKQcs3OqE3mkyCjmpoYxTk&e=> From: David Connors via ozdotnet <ozdotnet@ozdotnet.com<mailto:ozdotnet@ozdotnet.com>> Sent: Tuesday, July 30, 2024 2:17 PM To: ozDotNet <ozdotnet@ozdotnet.com<mailto:ozdotnet@ozdotnet.com>> Cc: David Connors <david@connors.com<mailto:david@connors.com>> Subject: Re: AI On Sun, 28 Jul 2024 at 23:16, Tom Gao via ozdotnet <ozdotnet@ozdotnet.com<mailto:ozdotnet@ozdotnet.com>> wrote: I wanted to get some feedback from you guys last time michael said maybe about 1-2% in improvement in usefulness to a seasoned dev. I've had ongoing robust conversations. Because I feel the benefits are completely overstated in general (open to being corrected). I don't think the benefit is overrated and we see huge value in the use of AI across all of the dev work we do. I think you're possibly looking at it glass half empty instead of glass half full. The question is not whether the AI is smarter than you, can write better code than you - the question is whether you get a great productivity boost in day to day activities. Co-pilot smashes boring drudge work like making constructors out of the park. You can use ChatGPT to break the back of time consuming but easy work - for example, upload a CSV and then ask it to write you the DDL for a table to store that and a stored procedure to do CRUD operations etc. It churns it out instantly. If you asked me to write an UPSERT statement in T-SQL or create a user in MySQL I would have to Google it. They're tasks that are easy, but also tasks that I seldom do so don't have the syntax front of mind. I can just leave out the middle-man and get the AI to do it for me. The most senior tech lead in my team believe it's a negative benefit. As in it can't understand complex business analyst requirements, nor debug codes, nor find / correct defects. All of our PRs are reviewed by AI before humans touch them (via Code Rabbit). People reviewing PRs are generally more senior, more expensive and time poor. Code Rabbit produces *really* good summaries of what is in the PR and the implications. It provides a lot of low level commentary that is useful to the dev's themselves before asking for a review. You can talk back and forth with Code Rabbit in the comments under the PR in GitHub and ask for suggestions etc. The effort to prompt engineer and also to correct what's generated is also understated. What sort of things are you asking it to do? If you're trying to get an LLM to write conceptually complex things then that might be where you have friction. Here's an example of a CodeRabbit review for a simple change done today in one of our systems together with example of dev conversation. The reviews of complex changes (I could not find a good example without internal information) are astonishingly good and the back and forth with the bot can be very nuanced (arguing the point on why there isn't actually a race condition in some code because it isn't considering this or that). This level of review / suggestion / fix cycle happens before a senior considers the PR. The poems are a nice touch :) [cid:ii_19102a35daead7999131] Conversation on that change with CodeRabbit: [cid:ii_19102a35dae11bfad142]
