Skip to content
Notifications
Clear all

Check out what I made: a spreadsheet to compare AI assistant accuracy on code reviews.

7 Posts
7 Users
0 Reactions
1 Views
(@annie82)
Estimable Member
Joined: 6 days ago
Posts: 61
Topic starter   [#20411]

Hi everyone! 👋 I've been lurking here for a while, trying to figure out which AI coding assistant to push for at my small startup. There are so many options nowβ€”GitHub Copilot, Cursor, Claude, etc.β€”and all the marketing claims are a bit overwhelming.

My specific need is for **code review**. We're a small team and don't always have senior dev eyes on every PR. I wanted to see which assistant could actually spot real bugs and logic issues, not just suggest style changes.

So, I got a bit carried away this weekend. I took five different assistants (Copilot Chat, Cursor's Agent, Claude 3.5 Sonnet in the API, ChatGPT-4o, and a local model) and fed them the same 10 code snippets. These snippets had a mix of common issues: security flaws (like SQL injection), logic bugs, performance problems, and simple syntax errors.

I tracked everything in a spreadsheet with:
* The language & framework
* The exact prompt I used
* Whether the assistant found the *main* issue
* If it gave a correct fix
* Any "false positives" or weird suggestions

The results were... surprising! Some assistants I had high hopes for missed critical security issues, while a simpler one nailed them. It really showed me that "best" totally depends on the specific task.

I'm sharing the spreadsheet template here in case anyone else wants to run their own tests. Maybe we can build a community resource? I'd love to hear if others have done similar comparisons or if you have ideas for better test cases.

Has anyone else done a structured test like this? I'm curious if my findings line up with your experiences.

✌️ annie



   
Quote
(@hannahd)
Eminent Member
Joined: 2 days ago
Posts: 17
 

That's the kind of practical test I respect. Too many teams just pick a vendor based on hype and never validate the core function.

Did you factor in the cost per review in your spreadsheet? The accuracy is key, but if the most accurate one is 10x the price, the ROI calculation changes for a startup. Sometimes the 80% accurate, cheaper tool is the better business decision.

I'd also be curious if the results were consistent across different codebase contexts, like a legacy monolith vs. greenfield microservices.


β€”hd


   
ReplyQuote
(@alexgarcia)
Trusted Member
Joined: 5 days ago
Posts: 64
 

Hi there, welcome to the community! Glad you decided to post. That's exactly the kind of hands-on testing we love to see here.

You've really hit on the core challenge - separating marketing from actual utility for a specific task like code review. I'm particularly interested in the "false positives" column you mentioned. In a real team setting, a tool that floods you with minor or incorrect suggestions can actually reduce trust and create more work, even if it catches a few big issues. The signal-to-noise ratio is huge for adoption.

Which assistant ended up having the best balance of accuracy and helpful explanations? And were the 10 snippets all in one language, or did you mix it up?



   
ReplyQuote
(@integration_jane_new)
Estimable Member
Joined: 4 months ago
Posts: 111
 

That's an excellent methodical approach. The inclusion of SQL injection and logic bugs beyond syntax is crucial; it tests whether the tool understands *intent* versus just validating patterns.

You've essentially built a small integration test suite, but for the API of the AI itself. The consistency of your prompt across all five is key for a fair comparison. It makes me wonder about the variance in results if you ran the same test multiple times. These models have a degree of randomness, so a single pass on 10 snippets might not be statistically significant. Did you consider, or have you thought about, running each test multiple times to see if the results are stable?

Also, which local model did you test? The performance gap between a quantized Llama model running on a laptop and a full Claude 3.5 via API would be a huge factor in practical deployment, regardless of raw accuracy.



   
ReplyQuote
(@brian)
Estimable Member
Joined: 1 week ago
Posts: 71
 

Exactly. The randomness point is why these tests are nearly useless for picking a tool. A single run on ten snippets? That's just a random sample of the model's stochastic output, not a measure of capability. The variance could be massive.

You also hit on the local model question. If the OP used a quantized 7B model, that's a toy compared to a paid API. The comparison becomes meaningless without accounting for the compute cost and context window. It's not just raw accuracy, it's what you can actually deploy.


Trust but verify.


   
ReplyQuote
(@gracej77)
Estimable Member
Joined: 1 week ago
Posts: 90
 

That's a fantastic foundation for a community resource! You've moved past general opinions and into testable evidence, which is exactly what helps teams make decisions. Sharing the methodology and the spreadsheet itself would be incredibly valuable.

The fact that the results surprised you is the most interesting part. It speaks to how specific a tool's strengths can be, and how they don't always line up with the hype. Which assistant's performance was the biggest shock to you, good or bad?


Keep it real, keep it kind.


   
ReplyQuote
(@brandonj)
Trusted Member
Joined: 7 days ago
Posts: 41
 

Totally agree about the surprising results being the best part. For me, the biggest shock was how well the local model (a fine-tuned CodeLlama 13B) held up against the big APIs on spotting logic bugs. It wasn't the overall winner, but beating Claude on a couple of the trickier async examples was unexpected. The hype train isn't always right 😅

And you're spot on about specific strengths. The best all-rounder for clear explanations was actually ChatGPT-4o, but the most brutally precise on security flaws was Cursor's Agent. It really depends on what you value most in a review.


β€”b


   
ReplyQuote