HN.zip

Benchmarking coding agents on Databricks' multi-million line codebase

133 points by tanelpoder - 58 comments
redmalang [3 hidden]5 mins ago
We have an internal proxy (that I've been meaning to open source for ages) that routes all llm usage at our company, which allows us to see data in realtime. Its been fascinating how rapidly Pi has been adopted. Moreover since its pretty hackable, we've been able to automatically aggregate context from pi sessions, which has resulted in Pi efficacy being higher as more people use it, putting in place a interesting virtuous loop. I didn't expect this outcome: for whatever reason I assumed proprietary harnesses fine tuned to work with a companies' models would work better? ps/random aside: there is something slightly off about Pi's edit command, we are planning to investigate this further and patch this as we have quite a few session traces now..
lukax [3 hidden]5 mins ago
Yes, this is a known issue. A significant amount of Edit tool calls fails in Pi witg newer models.

https://lucumr.pocoo.org/2026/7/4/better-models-worse-tools/

est [3 hidden]5 mins ago
cyanydeez [3 hidden]5 mins ago
I don't understand peoples expectation. If our language skills were as non-ambiguous as a coding language, we'd have solved world hunger by now.

So why would we expect all these bizarre bizantine language models to all conform to how a request is both made, expected and massaged.

For awhile, I was getting bizarre opencode tool errors where the only problem was the model was passing in a "1.0" or "0.0" where the harness dutifully wanted an integer. Of course 0.0 is the same as an integer in practical operations.

sgc [3 hidden]5 mins ago
I have one core complex task where there are a number of simple errors like this. The easiest thing for me was to just have a post-processing script that performs: lint > mark known fail-early results > fix common errors (all formatting or type errors right now) > relint > final pass / fail > pass to next step (retry with tweaks / user in the loop since I don't have the token budget to just blindly keep trying the same thing).
sanderjd [3 hidden]5 mins ago
I keep hesitating to use Pi because I primarily use Claude and I worry it will be much more expensive to pay for API usage rather than the bundled subscription usage. But I haven't actually evaluated the cost tradeoff. Should I get over this hesitance and dive into Pi?
redmalang [3 hidden]5 mins ago
Aside 2: Anecdotally we found that Pi performs more or less on par with native harnesses at lower cost on decently specified prompts. It is also phenomenal at context cacheing especially on Deepseek models (its hard to precisely attribute credit here are my understanding is this is a DS speciality). But it fails much worse on poorly drafted prompts. I'm generalising but native harnesses seem to be better kind of flailing along on those.
swingboy [3 hidden]5 mins ago
Is it because Pi’s default system prompt is so simple?
cyanydeez [3 hidden]5 mins ago
of course it is; these entire systems are about priming the LLM to perform X task; if it's a coding harness, giving it very little priming for a task is going to make it grasp at straws.
sgc [3 hidden]5 mins ago
Can anybody share a tested system prompt they use for general coding tasks in pi?
Sphax [3 hidden]5 mins ago
> we've been able to automatically aggregate context from pi sessions

what do you mean by this ? do you rewrite the context in your proxy ?

N_Lens [3 hidden]5 mins ago
I imagine they're capturing all the tokens+context from pi sessions from every developer.
redmalang [3 hidden]5 mins ago
Yeah.
pbowyer [3 hidden]5 mins ago
Can you say more? This sounds like it could be more useful than trying to build a knowledge base (say qmd) and then get the models to search it for the right context each time.
redmalang [3 hidden]5 mins ago
This is in fact what we do (with higher order abstractions now built on top of this). This builds self evolving interactive knowledge base and puts it into a QMD searchable index. The indexer is already open source: https://github.com/jibs/duffel
Schlagbohrer [3 hidden]5 mins ago
Can you explain context aggregation here more? What is that? What are you doing and how is it helping?
HarHarVeryFunny [3 hidden]5 mins ago
Wow!

It's great to see a large-scale real-world benchmark from a user of these tools, as opposed to the the benchmaxxed results from the vendors themselves. Also great to see different harnesses being tested, with considerably different results.

Definitely a few surprises here:

1) GLM 5.2 using Pi performs identically in terms of pass rate (~87.5%) to Opus 4.8 high using Claude Code, but significantly cheaper ($1.25 per task vs $2)

2) Absolute best pass rate (90%) was from Opus 4.8 x-high using Pi, beating out Opus 4.8 using Claude Code

3) Pareto frontier performance from any of the models (Opus 4.8, GPT 5.5, GLM 2.5) was using Pi rather than native harnesses

Apparently Pi used 3x less context than Claude Code, and one takeaway is to use Pi regardless of what model you are using. The other takeaway is that in real-world performance GLM 5.2 is the equal of Opus 4.8 unless you run Opus 4.8 on x-high in which case you can eke out a 2.5% increase in pass rate at the expense of doubling your cost over GLM 5.2

zaphar [3 hidden]5 mins ago
The catch-22 here is that you still save money using Claude Code directly here if you are on one of their subscription plan due to how heavily they are subsidizing that. Using Pi means you are using the API which is both a more accurate pricing model but also a more expensive one.
HarHarVeryFunny [3 hidden]5 mins ago
True, but OpenAI are OK with using their subscription plans with Pi, so GPT 5.6 with Pi may be a good combination.

There seems to be a lot of good buzz about GPT 5.6 on Twitter - people (incl. OpenCode team) preferring it to Fable 5.

ry_t [3 hidden]5 mins ago
Pi has a subscription flow for Claude Code. Are they goading people to get banned or did they figure out a way to work with the subscription?
sgc [3 hidden]5 mins ago
It seems like they are actually using the subscription providers' respective cli tools and managing context for them. In which case I believe it is not against the ToS any more than invoking codex cli from a custom python script would be? I personally cannot find an openai-hosted clarification, just on hn and x.
agentdev001 [3 hidden]5 mins ago
Obligatory yes, but only if you're subscription-based and not pay-per-token as enterprise users are.
virgilp [3 hidden]5 mins ago
It seems that pass rate decreases with effort increase, on GPT5.5? This is highly counter-intuitive and I don't see any explanation, any idea why they'd get this result?
anentropic [3 hidden]5 mins ago
> the results showed clear clustering of the models and harnesses into 3 capability tiers

pretty sure the only thing making that 'clear' is the coloured stripes, if you took that away it'd look like two tiers

good result for GLM 5.2 though

and Sonnet 5 seems like a waste of time

yodon [3 hidden]5 mins ago
I wish they'd do a follow-on post drilling into the impact of the programming language on cost-per-task, specifically looking at cost to complete tasks in mainstream strongly typed languages (eg. C#, TypeScript) vs dynamic languages (eg. Python, JavaScript). Does the additional verbosity of the language help or hurt cost per task?
trollbridge [3 hidden]5 mins ago
I don't have hard data, but we have shifted to Rust and Swift (for frontend UI) for the bulk of our dev simply because it is a lot more predictable, easier for tool calls to edit, the build steps produce easier output for the agent to loop on, the tests are easier to write/get results from, etc., although I am mostly measuring this in time, not cost.

Once the thing is rock-solid it's relatively easy to do a Swift->HTTP/HTML/CSS/React/TypeScript conversion.

rootatixww3 [3 hidden]5 mins ago
for that you would need to compare the same task implemented in two different languages - C# and Python for example, no?
cpard [3 hidden]5 mins ago
This was mostly because Sonnet 5 worked longer and read more to get there, consuming 1.9x more tokens.

I have experienced similar behavior between opus and haiku when benchmarking Dara engineering tasks. The “cheaper” model takes many more turns to figure out the task and this is without taking into account other important factors.

Another interesting behavior that I observed is that Haiku tended to cheat more maybe because it was having a harder time to find the root cause of the problem.

Benchmarking and evaluation of agentic systems is very interesting and if there’s one thing that someone should keep from the Databricks post is how important is for everyone to build and run their own.

lukax [3 hidden]5 mins ago
Could it be that users of Pi are more senior and know better how to prompt and that's why the pass rate is higher?
rootatixww3 [3 hidden]5 mins ago
they explain this is a benchmark, all models/harnesses receive the same prompt
Schlagbohrer [3 hidden]5 mins ago
Anthropic is not beating the charges that they inflate token consumption with their own harness given these findings that Pi is 2.2x more efficient at token management. Big "toothpaste ads tell you to use way too much toothpaste" energy.
yigitcan07 [3 hidden]5 mins ago
Would be great to see time spent per task per model. Especially since article references 390+ tokens per second for GLM5.2.
nkzd [3 hidden]5 mins ago
How is Pi so efficient? You'd think agent harness made by model makers would perform better.
HarHarVeryFunny [3 hidden]5 mins ago
Different incentives. Claude Code makes more money for Anthropic by generating larger contexts. Anthropic also recently changed their tokenizer so the exact same code input creates 30% more tokens, so there's a pattern there.
cyanydeez [3 hidden]5 mins ago
they spent very little time validating what they're doing, and it works by not doing much of anything. If you spent a month figuring out a specific model+harness, you'd be way more efficient.

Other hanresses are doing overkill so they can work with any model.

falaki [3 hidden]5 mins ago
1) Many models are now competitive at the top tier, including open source. 2) GLM 5.2 in particular was a major step forward in open source coding agent performance, 3) Harnesses make a huge difference in cost-performance. 4) Cheaper per-token does not imply cheaper per-task.
falaki [3 hidden]5 mins ago
Also they suggest every company should build their own benchmark and repeat these tests with new models instead of relying on the SWE bench.
fmind-dev [3 hidden]5 mins ago
It takes time and effort to build such benchmark. It works at Databricks scale, I'm not sure smaller companies are ready to invest on internal benchmarks.

But they are more vendor neutral, now they don't sell their own model. It's interesting from a benchmark point of view.

zipy124 [3 hidden]5 mins ago
I'd like to know what their config with pi is like. Is it vanilla, is it oh my pi etc.... This seems like important info.
pianopatrick [3 hidden]5 mins ago
Seems like for a hobby project $1 or $2 per task would add up a bit, depending on how many tasks you need to do. I mean it makes sense for a software company
jkwang [3 hidden]5 mins ago
The repo-scale angle is the useful part here. Small synthetic tasks miss a lot of the integration and context retrieval failures you only see in a codebase this large.
throwa356262 [3 hidden]5 mins ago
Is there any technical analysis of why contex grows slower in Pi compared to codex and CC?
rootatixww3 [3 hidden]5 mins ago
different system prompts, codex will have system prompt telling the model to gather a lot more context before starting work
dirkc [3 hidden]5 mins ago
> as we aggressively adopt AI for engineering

Why do we need to aggressively adopt things rather than thoughtfully adopt things?

It sounds like they are probably punching AI and engineers in the process

simianwords [3 hidden]5 mins ago
What if other competing companies adopt it aggressively and push out features faster and get more market share?

What if pushing features faster brings more money because users like the features?

adhamsalama [3 hidden]5 mins ago
Did any company achieve this?

Have we seen a company fail because they're not adopting AI as much as their competitors?

zkmon [3 hidden]5 mins ago
> Databricks’ multi-million line codebase

The combined size of codebases for the underlying opensource products (Apache Spark etc) might be around 1M lines, I think. Why does the orchestration/management layer, that is "databricks", exceed the sizes of the core products?

trollbridge [3 hidden]5 mins ago
Because if they're like previous places I worked out with proprietary commercial codebases, the code is old, has been around a long time, and trying to shrink it is not a priority.

It's a good stress test for the LLM because it is not an "ideal" codebase.

alexott [3 hidden]5 mins ago
:facepalm: "orchestration/management layer" that just runs dozens of millions of VMs per day, across the three clouds, with things like model serving, AI gateway, OLTP (Lakebase/Neon), Unity Catalog, etc.

Forget Databricks == Apache Spark...

ozgrakkurt [3 hidden]5 mins ago
Old codebase, you always add code and never remove it. So it is expected to be like this.

Deleting code is difficult and almost never makes sense afaik

tijs [3 hidden]5 mins ago
Every line you delete is a line you no longer need to maintain. We aggressively prune old code in our apps and it has definitely helped with maintainability. For a mobile app it’s also code you don’t ship so that’s a nice bonus which I guess is not much of an argument on a backend codebase
wwind123 [3 hidden]5 mins ago
On one hand, I understand that some old code is hard to delete because it's hard to detangle a lot of the legacy dependency. On the other hand, too much useless old code existing in the code base by itself could become a big maintenance burden for both humans and AI. In some cases at some point it might become more economical to just invest a bunch of resource to detangle the dependencies to be able to remove the old code.
hasyimibhar [3 hidden]5 mins ago
At huge companies, it's hard to prioritize this because it's hard to pin dollar values to removing legacy code, while it's easier to show how building feature X will earn the company $Y amount of revenue. And because of that, there is also no incentive to do it, you don't get promoted by deleting old code, you get promoted by showing how your effort helped contribute to company revenue. At my previous company (100+ engineers, hundreds of microservices), teams that regularly clean legacy codebase tend to be platform teams (cost centers), while teams that struggle to get these prioritized are product vertical teams (revenue centers).
appplication [3 hidden]5 mins ago
LoC isn’t a super helpful metric so I think the better question is why is the headline using it. I can say I’ve personally created about 200k LoC code in the last 5 years and most of that has some value. But it really doesn’t say might about how much value or really anything else meaningful.
InsideOutSanta [3 hidden]5 mins ago
They're probably mentioning the size of the code base as an indicator for how difficult it is for an LLM to understand where and how to make changes.
tw1984 [3 hidden]5 mins ago
very interesting results!

GLM performed extremely well. we need GLM-6!

vegetablefinger [3 hidden]5 mins ago
[flagged]
appplication [3 hidden]5 mins ago
Welcome to the world, young robot