We all know that trying to get non-pozzed responses to anything involving hot button political/social topics from Big Tech trained AI models is a fool's errand, but I'm wondering if anyone has found them to be of any use when it comes to programming. Despite what a number of my professors say, some of whom are definitely not diversity hires, I haven't found them to be of any use. Maybe it's because I'm only asking hard or niche questions when I can't find the answer elsewhere, but I haven't gotten any help from the bots in my programming tasks. The last time I tried it invented modules to a package out of thin air. Had those modules actually existed I wouldn't have needed to ask the question to begin with. From what I've seen the most it can do is help pajeets cheat in their programming 101 classes. Has anyone here had a different experience?
You're viewing a single comment thread. View all comments, or full comment thread.
Comments (37)
sorted by:
Another thing I'll add you can do that I have found VERY useful.
You can paste in SQL table schema for multiple tables. You can then post in some queries and say "optimize this SQL query, given the above tables."
I had one very complicated query with like 10 tables, weird conditionals, weird aggregates, etc., and I just could not make the thing perform any better. A friend tried too.
ChatGPT did an amazing job optimizing the query. It was amazing. Out of about a dozen queries I tried this on, chatGPT got 2-3 MUCH faster, ~2 faster, and then did nothing for the rest.
You could also run the query analyzer of just about any modern database engine since about 2000 and it would give you not only suggestions for how to improve it, but also note any missing indices that it could use to potentially speed it up by orders of magnitude.
Yeah, I did explain/explain analyze, I did index analysis. This was a complicated query with a lot of joins and subqueries. ChatGPT completely reorganized it. It was great.