A Paradigm Shift in Efficiency - Claude Sonnet 4 + Gemini CLI

[Deleted]

Efficiency improvements are amazing!

 

[Isaac]

Now here's the kicker -- "Understanding MCP protocol: 4-6 hours" MCP protocol has only been in existence for two or three months {possibly six months} I'm not sure when it came on the scene !!!

The point is, it's brand new technology --- something else to learn, and in six months time it will be replaced with something else !!! --- Get it? It's not just that it's difficult learning how to use these new technologies it's that once you've invested the time and effort into learning it something else will come along --- AI shortcuts this major obstacle --- Of course, in another year, we won't need to know anything! You will just say "do this and it's done!"

But I assume AI will stumble in giving good advice on new tech in a way that corresponds with the limited information available on it - UNLESS it's one of these technologies that's released with incredibly good and complete documentation that AI can leverage in which case it maybe won't stumble. We won't have to keep learning new things that much - but it is so helpful to have a programmer's mindset/learning to start with to help steer the AI. You have this thus you have had a lot of success with AI. I worry about vibe coding from newbies. 'vibe coding' as they say

 

[GPGeorge]

I just surfaced from a frustrating vibe session with Claude. I asked for a set of Stored Procedures to manage extended properties on tables.

Long story short, the internals of reading, listing, appending and deleting extended properties are, as you might surmise, cryptic. So the first request was to upgrade the stored procs to use plain language names instead. That took four rounds * 2 or 3 iterations, for the four stored procs.

Then, during UAT, I discovered an inconsistency in the way Claude converted those cryptic internal properties to plain language terms in each stored procedure! That was something I didn't expect. I had asked for all four together, but Claude treated them as unique things.

That lead to four more rounds of one or more iterations. It managed to catch on and not repeat the errors in the final sps.

If I were a newbie, I wouldn't have known if the problems were inconsistencies, hallucinations, or just passive-aggressive obstruction. That's all aside from the question of emerging technologies. Extended properties is well established, but less commonly used tech. It still took multiple iterations, and multiple tests in between each round.

New tech? That could be an interesting process.

 

[Isaac]

I just surfaced from a frustrating vibe session with Claude. I asked for a set of Stored Procedures to manage extended properties on tables.

Long story short, the internals of reading, listing, appending and deleting extended properties are, as you might surmise, cryptic. So the first request was to upgrade the stored procs to use plain language names instead. That took four rounds * 2 or 3 iterations, for the four stored procs.

Then, during UAT, I discovered an inconsistency in the way Claude converted those cryptic internal properties to plain language terms in each stored procedure! That was something I didn't expect. I had asked for all four together, but Claude treated them as unique things.

That lead to four more rounds of one or more iterations. It managed to catch on and not repeat the errors in the final sps.

If I were a newbie, I wouldn't have known if the problems were inconsistencies, hallucinations, or just passive-aggressive obstruction. That's all aside from the question of emerging technologies. Extended properties is well established, but less commonly used tech. It still took multiple iterations, and multiple tests in between each round.

New tech? That could be an interesting process.

That makes me think for some reason of an article I read where programmers used AI and they thought that they were 20% faster but the data showed they were 19% slower

 

[The_Doc_Man]

That makes me think for some reason of an article I read where programmers used AI and they thought that they were 20% faster but the data showed they were 19% slower

Which tangentially reminds me of that old saying about being careful: If you haven't got time to do it right the first time, how will you EVER have enough time to go back and fix it?

 

[GPGeorge]

That makes me think for some reason of an article I read where programmers used AI and they thought that they were 20% faster but the data showed they were 19% slower

In this case, though, I would have spent even more time figuring out the code in the first place.

Also, the quality of the resulting code has to be taken into consideration as well.

 

[Isaac]

In this case, though, I would have spent even more time figuring out the code in the first place.

Also, the quality of the resulting code has to be taken into consideration as well.

I only commented that as I couldn't tell what your own opinion was about the overall time savings of it.
I will say ChatGPT is helping me a lot these days and I love its Memory feature - for example, we use Redgate at work and you can edit your preferred SQL formatting style, (so when you click Format SQL it will remember), but even this feature is inferior and doesn't quite cover all bases compared to when I tell ChatGPT "for joins, always put an entire statement that results in a new relation on a single line", etc. etc., it will never mis-format my sql again! I do like AI some days. Other days it scares me, depends on what I am working on

 

[GPGeorge]

Interesting article on developers losing their trust in AI ..

Trust in AI coding tools is plummeting - LeadDev https://share.google/rhZQHiiRil0lu6D46

Isn't it to be expected that increased usage would lead to better understanding of the strengths and weaknesses of AI.

Unrealistic hype was behind the initial exuberance for AI and also behind claims that it was going to end all human employment as we knew it.

It's always been thus with new technologies. Reference the dot com bubble and burst of the late 1990's.

I bet a good historian could document the cycle for many, many such advances in human technology and understanding.
Initial awe at the brilliant new technology, followed by unrealistic predictions of world-changing implementation, followed by disillusionment, disappoint and regret. And finally by a period of cold-eyed experimentation, development and advancement.

We're on the cusp of a healthy reset, I think. We've been skeptical of the new phenomenon and we've been excited by the unfolding possibilities. And now we are about to find out where the limitations really are. In the not too distant future we'll become accustomed to what can and can't be done and take off on a new kind of productivity.

 

[amorosik]

What you mean exactly "..which has a copy of my whole project as text files.." ???
You have exported all the objects contained in an Access project using tools like vcs-access ?
And can you have them analyze a project composed of hundreds of files?

 

[amorosik]

Yes that's right ...

No, not MS Access, haven't tried that...

A python project...

File types, Json, CSS, html, python, XML, JS script, some others .. any file which is text based.....

And how do you send them all together to the Claude system?
And can Claude 'understand' the program flow?