> AI Tards: I Have A Requirement That Any Beginner Programmer Could Do, Probably 100% Accurately And Without Supervision. Can An AI Do This For Me Accurately?

Why don't you enter your entire question into Claude & ChatGPT for a response?

SamplesBoi wrote:

So I have this crappy old medium sized WinForms/C# SQL Server app.  It has some flaws, totally my fault.  One thing I don't like is it uses a mix of stored procedure calls to do database transactions and embedded SQL, about 50/50.  And the embedded SQL is 60% not parameterized, using just (unsafe) string concatenation.  I'd love to go through the program and clean it up so I don't look like a tard anymore.  I'd like to convert both to parameterized SQL so it is consistent and I don't need a bunch of stored procedures anymore and I lose the unsafeness of the unparameterized SQL.   Also, I'd like it to move all the SQL statements into one source file as constants.  That would require knowing a little bit about how SQL works, string manipulation, what database to look up the stored procedures into to get the SQL out, etc.  But it's extremely mechanical and requires zero judgment.  Could an AI do that?  NE1 KNOA?

~308 files, 32MB of source code.

have you seriously never used AI - like at all? It could easily do this. You'd have to be the "supervisor" and tweak it with some iterations - but this question makes it sound like you've never even tried using AI for anything??

With your intrinsic knowledge of the what you're trying to do it would be faster to use AI to do this than try to pawn it off/explain it to some other dev.

., wrote:

have you seriously never used AI - like at all? It could easily do this. You'd have to be the "supervisor" and tweak it with some iterations - but this question makes it sound like you've never even tried using AI for anything??

With your intrinsic knowledge of the what you're trying to do it would be faster to use AI to do this than try to pawn it off/explain it to some other dev.

If you haven't noticed, he's really dumb.

He's admitted to working a lower wage computer grunt job. I'm guessing he's a government employee.

Opus 4.6 would have no problem doing this in one shot, trevs are obsolete

SamplesBoi wrote:

You see the size of this project I just mentioned?  It runs a private company, ever single person uses it including the CEO and head accountant.  It feeds field service mobile apps that the field staff use.  It sends and receives both texts and emails to the customers and sends and receives data from the website the customers use.  It's 22 years of work at this point.  Part time (other than the first few years).  I worked other companies full time as I did this, including 3 Fortune 500 companies.

Of course this is not the Android or website (PHP) code, that is a different code base that I 100% did as well.

It's garbage code by your own admission (unsafe SQL, etc), probably cut and pasted from Stack Overflow.

The fact that you are proud of that sack of shyt speaks volumes. You're probably the only one who can decipher the spaghetti code so they keep you on.

We just replaced something similar with NetSuite.

wrote:

We just replaced something similar with NetSuite.

What did your customization cost?  Current company I am at did something similar with a similar cloud ERP product and it's the customization that gets you, not licensing.  It's been hundreds of thousands of dollars for customization and now it maybe 80% aligns with their business and their manufacturing requirements.  The thing I have made over the last 20 years for this one client is very unique at least in the way it handles manufacturing, installation, and service because of the way they do business.  Probably 80% of all work they have ever done is unique in major ways.  They don't have a lot of stock parts or any pure stock products.

Sockpuppet wrote:

I’d approach it in batches. Think about how you’d do the work in phases. Then direct the AI to do the same. Heekee says it could do it in one turn. I don’t know. Maybe with some great prompt. If you go in phases you can check its work after each phase and see what it is actually doing. This helps you supervise and learn as well.

It's should be very easy to batch this.  Each file can be done separately, all the AI has to know is how to recognize embedded SQL and then parameterize it and recognize SP calls and then look up the code for that SP and rewrite the SP call as a parameterized embedded SQL statement.  When it can do the most complex file competently, it should be able to do them all competently.