Wow.
2000x worse, huh?
I mean... I'm impressed that it runs, passes unti tests, and 'works', but is also that much worse.
That's a kind of achievement.
Not a useful kind, but... impressively bad.
Also it’s probably incredibly difficult to optimize a huge LLM-generated codebase since there are no human authors who know it intimately to begin with.
Having a stable set of individuals with a deep understanding of 'how things work' is so totally anathema to the modern paradigm of 'every coder is is a contractor, basically'.
Everybody wants to do software development, but doesn't want to foster software developers.
So, they try and build machine god to replace us, and as most of us predicted... didn't work out so well, but goddamnit, they'll burn a trillion dollars before they let their ego take a hit.
... oh well, I guess.
@artifex
It's even worse than that: profilers rub your code 20-100 tubes slower, which, if performance is OKish to begin with is workable. 2000x too slow? Can't even profile!
The 2000x difference is for more complex workloads. It has ok performance for very simple queries.
So not quite as bad as the headline number suggests. But still very bad and not a viable alternative.
I mean, 2x would already be unacceptable.
I mean, on the one hand, its SQLite.
On the other hand...
... arguably the entire point of a database language is to efficiently handle complex workloads.
And then when you remember that... this was a project, in development, that cost time, money, energy, made RAM prices go up by maybe ¢22 per GB all on its own...
This is an insane negative return on investment.
Like imagine if you paid the same amount of money to ... people, a contracted firm, and they handed you this.
You'd potentially be firing them or suing them for breach of contract, blacklisting them as far and wide as you could.
I couldn't find if they were able to fix the identified bugs, seems like an important detail. How far does a month of LLM plus a month of talent get you?
They probably dont care. They did this to generate headlines about how capable their AI is. It has served its purpose. So long as all of the investors only saw the propaganda articles the line will only go up and they can abandon this project.
The propaganda articles about how the LLM missed critical logic and that it performs worse than SQLite?
I'm less less interested in the extreme skepticism or hype.
The project is an impressive demonstration from a pure technical perspective. I couldn't imagine 5 years ago a model being able to rewrite such a complex project.
Reminds me of the Claude fluff article that mentions that reverts have only increased 0.04%.
It made big noise that the number of Pull Requests has doubled though.
Logically because you have one PR from an LLM, then another by a human to fix the LLM slop.
Or a large number (vast majority I'd bet) of LLM generated PRs are going unmerged. No need to revert something that hasn't been merged.
Tbh I see myself using AI for shits and giggles. (nothing helpful)
I try not to use it alot due to the ethics it comes with it.
In fairness to LLMs, (which I run locally) I've been able to use them for like, bits of code that are roughly 200 lines or less.
Or like, feed it a code base and say hey, make sure all the comments are formatted the same way.
But uh, for... trying to engineer an entire system?
Nope nope nope, they get very confused, very fast, as overall conplexity increases.
@rimu How does it get worse at all?! SQLite has quite a few vtables, and Rust has monomorphisation, so it should be possible to do better on benchmarks.
(I have occasionally thought about rewriting SQLite in Rust before regaining my senses.)
There are some things it can do well, like collecting / organizing certain data out of large documents. Sort of like a recursive-multi-google operation
@rimu "Fake it 'till you make it" does not work with artefacts. It may help you form habits, but if it's not your attitude that is the problem, but rather the tool, then "Fake it 'till you make it" *will lead to the emperors new clothes* .
Tech related news and discussion. Link to anything, it doesn't need to be a news article.
Let's keep the politics and business side of things to a minimum.
No memes