709
this AI thing (lemmy.world)
you are viewing a single comment's thread
view the rest of the comments
[-] DarkMessiah@lemmy.world 107 points 1 year ago

Honestly, the best use for AI in coding thus far is to point you in the right direction as to what to look up, not how to actually do it.

[-] DJDarren@thelemmy.club 30 points 1 year ago

That’s how I use Chat GPT. Not for coding, but for help on how to get Excel to do things. I guess some of what I want to do are fairly esoteric, so just searching for help doesn’t really turn up anything useful. If I explain to GPT what I’ll trying to do, it’ll give me avenues to explore.

[-] TheDoozer@lemmy.world 4 points 1 year ago

Can you give an example? This sounds like exactly what I've always wanted.

[-] gornius@lemmy.world 10 points 1 year ago* (last edited 1 year ago)

I have a spreadsheet with items with their price and quantity bought. I want to include a discount with multiple tiers, based on how much items have been bought, and have a small table where I can define quantity and a discount that applies to that quantity. Which Excel functions should I use?

Response:

You can achieve this in Excel using the VLOOKUP or INDEX-MATCH functions along with the IF function.

Create a table with quantity and corresponding discounts.

Use VLOOKUP or INDEX-MATCH to find the discount based on the quantity in your main table.

Use IF to apply different discounts based on quantity tiers.

[-] TheDoozer@lemmy.world 2 points 1 year ago

That's really cool, I gotta try that in the future. Thanks!

[-] Gork@sopuli.xyz 1 points 1 year ago

Index / Match gang represent. Much more flexible than Vlookup.

[-] veni_vedi_veni@lemmy.world 1 points 1 year ago

It's shunned upon in the Excel pro scene (shout-out to my boi Makro), but xlookup can be used instead

[-] FrostyTrichs@lemmy.world 2 points 1 year ago

Using AI in this way is what finally pushed me to learn databases instead of trying to make excel do tricks it's not optimal for anyways.

I tried a bunch of iterations of various AI resources and even stuff like the Google Sheets integration and most of them just annoyed me into finding better ways to search for what I was trying to do. Eventually I had to stop ignoring the real problem and pivot to software better optimized for the work I was trying to do with it.

[-] Baizey@feddit.dk 2 points 1 year ago

That's exactly how I use it (but for more things than excel), it works pretty well as a documentation 'searcher' + template/example maker

[-] 0x4E4F@infosec.pub 14 points 1 year ago* (last edited 1 year ago)

Yeah, that's about it. I've trown buggy code at it, tell it to check it, says it'll work just fine... scripts as well. You really can't trust anything that that thing outputs and it's more than 1 or 2 lines long (hello world examples excluded, they work just fine in most cases).

[-] ignotum@lemmy.world 6 points 1 year ago

Have you looked at the project that spins up multiple LLM "identities" where they are "told" the issue to solve, one is asked to generate code for it, the others "critique" it, it generates new code based on the feedback, then it can automatically run it, if it fails it gets the error message so it can fix the issues, and only once it has generated code that works and is "accepted" by the other identities, it is given back to you

It sounds a bit silly, but it turns out to work quite well apparently, critiquing code is apparently easier than generating it, and iterating on code based on critiques and runtime feedback is much easier than producing correct code in one go

[-] DanVctr@sh.itjust.works 3 points 1 year ago

The software that implements multi agents called ChatDev, it's significant more capable than one agent working alone. The ability to critique and fix bugs in the code in an iterative process gives a massive step up to the ability of the AI to program.

Granted it might still get in a loop between the programing and testing departments, but it's a solid step in the right direction.

[-] ignotum@lemmy.world 1 points 1 year ago

I was thinking of AutoGPT, but nice to see there are multiple projects taking a crack at this approach

[-] 0x4E4F@infosec.pub 2 points 1 year ago

Hm... that sounds interesting... a link to this AI?

[-] ninjan@lemmy.mildgrim.com 2 points 1 year ago

There is a (non-meme) reason why Prompt Engineer is a real title these days. It takes a measure of skill to get the model to focus on and attempt to solve the right question. This becomes even more apparent if you try to generate a product description where a newb will get something filled with superlative lies and a pro will get something better than most human writers in the field can muster for a much lower cost per text (compared to professional writers, often on par or more expensive than content farms). AI is a great tool, but it's neither the only tool (don't hammer in screws) nor is it perfect. The best approach is to let the AI do the easy boiler plate 80% then add that human touch to the hard 20% and at most have the AI prepare the structure / stubs.

[-] the_sisko@startrek.website 10 points 1 year ago

I'm totally willing to accept "the world is changing and new skills are necessary" but at the same time, are a prompt engineer's skills transferrable across subject domains?

It feels to me like "prompt engineering" skills are just skills to compliment the expertise you already have. Like the skill of Google searching. Or learning to use a word processor. These are skills necessary in the world today, but almost nobody's job is exclusively to Google, or use a word processor. In reality, you need to get something done with your tool, and you need to know shit about the domain you're applying that tool to. You can be an excellent prompt engineer, and I guess an LLM will allow you to BS really well, but subject matter experts will see through the BS.

I know I'm not really strongly disagreeing, but I'm just pushing back on the idea of prompt engineer as a job (without any other expertise).

[-] ninjan@lemmy.mildgrim.com 2 points 1 year ago

We're not talking small organizations here, nor small projects. In those cases it's true that you can't "only" do prompt engineering but where I see it is in larger orgs where you bring into the team the know how about how to prompt efficiently, how to do refinement, where to do variable substitution and how, etc etc. The closest analogy is specific tech skills, like say DBs, for a small firm its just something one backend dude knows decently, at a large firm there are several DBAs and they help teams tackle complex DB questions. Same with say Search, first Solr and nowadays Elastic. Or for that matter Networks, in many cases there might be absolutely no one at the whole firm that knows anything more than the basics because you have another company doing it for you.

[-] the_sisko@startrek.website 2 points 1 year ago

The closest analogy is specific tech skills, like say DBs, for a small firm its just something one backend dude knows decently, at a large firm there are several DBAs and they help teams tackle complex DB questions. Same with say Search, first Solr and nowadays Elastic.

Yeah I mean I guess we're saying the same thing then :)

I don't think prompt engineering could be somebody's only job, just a skill they bring to the job, like the examples you give. In those cases, they'd still need to be a good DBA, or whatever the specific role is. They're a DBA who knows prompt engineering, etc.

[-] Cannacheques@slrpnk.net 0 points 1 year ago

To be fair, in my mind most AI is kind of half baked potential terminator style nightmare fuel for the average person

[-] 0x4E4F@infosec.pub 0 points 1 year ago

To be honest, I just gave up on it regarding code. Now I use it mostly for getting info into one place when I know it's scattered all over the web.

[-] guy@lemmy.world 6 points 1 year ago

I've found it's best use to me as a glorified auto-complete. It knows pretty well what I want to type before I get a chance to type it. Yes, I don't trust stuff it comes up with on its own though, then I need to Google it

[-] infamousta@sh.itjust.works 4 points 1 year ago

Yeah, I find it works really well for brainstorming and “rubber-ducking” when I’m thinking about approaches to something. Things I’d normally do in a conversation with a coworker when I really am looking more for a listener than for actual feedback.

I can also usually get useful code out of it that would otherwise be tedious or fiddly to write myself. Things like “take this big enum and write a function that converts the members to human-friendly strings.”

[-] TheBlue22@lemmy.blahaj.zone 3 points 1 year ago

100% this yeah.

[-] PrMinisterGR@lemmy.ml 2 points 1 year ago

All the hype are grifters and Google trying to convince people this isn’t just a search engine assistant.

[-] criticalimpact@lemm.ee 2 points 1 year ago

Well we need something now that google is absolute dogshit at providing useful results XD Maybe not AI though

[-] explodicle@local106.com 2 points 1 year ago

I think of it as a step between a Google search and bothering actual people by asking for help.

[-] Karyoplasma@discuss.tchncs.de 1 points 1 year ago

Tell ChatGPT you want to do the project as an exercise and that it should not write any pseudocode. It will then give you a high-level breakdown which is usually a decent guide line.

this post was submitted on 05 Dec 2023
709 points (96.7% liked)

Lemmy Shitpost

27185 readers
4163 users here now

Welcome to Lemmy Shitpost. Here you can shitpost to your hearts content.

Anything and everything goes. Memes, Jokes, Vents and Banter. Though we still have to comply with lemmy.world instance rules. So behave!


Rules:

1. Be Respectful


Refrain from using harmful language pertaining to a protected characteristic: e.g. race, gender, sexuality, disability or religion.

Refrain from being argumentative when responding or commenting to posts/replies. Personal attacks are not welcome here.

...


2. No Illegal Content


Content that violates the law. Any post/comment found to be in breach of common law will be removed and given to the authorities if required.

That means:

-No promoting violence/threats against any individuals

-No CSA content or Revenge Porn

-No sharing private/personal information (Doxxing)

...


3. No Spam


Posting the same post, no matter the intent is against the rules.

-If you have posted content, please refrain from re-posting said content within this community.

-Do not spam posts with intent to harass, annoy, bully, advertise, scam or harm this community.

-No posting Scams/Advertisements/Phishing Links/IP Grabbers

-No Bots, Bots will be banned from the community.

...


4. No Porn/ExplicitContent


-Do not post explicit content. Lemmy.World is not the instance for NSFW content.

-Do not post Gore or Shock Content.

...


5. No Enciting Harassment,Brigading, Doxxing or Witch Hunts


-Do not Brigade other Communities

-No calls to action against other communities/users within Lemmy or outside of Lemmy.

-No Witch Hunts against users/communities.

-No content that harasses members within or outside of the community.

...


6. NSFW should be behind NSFW tags.


-Content that is NSFW should be behind NSFW tags.

-Content that might be distressing should be kept behind NSFW tags.

...

If you see content that is a breach of the rules, please flag and report the comment and a moderator will take action where they can.


Also check out:

Partnered Communities:

1.Memes

2.Lemmy Review

3.Mildly Infuriating

4.Lemmy Be Wholesome

5.No Stupid Questions

6.You Should Know

7.Comedy Heaven

8.Credible Defense

9.Ten Forward

10.LinuxMemes (Linux themed memes)


Reach out to

All communities included on the sidebar are to be made in compliance with the instance rules. Striker

founded 2 years ago
MODERATORS