a recent attempt to rewrite SQLite in Rust using AI. “It passed all the unit tests, the shape of the code looks right,” he said. It’s 3.7x more lines of code that performs 2,000 times worse than the actual SQLite. Two thousand times worse for a database is a non-viable product. It’s a dumpster fire. Throw it away. All that money you spent on it is worthless."

Insurers, he said, are already lobbying state-level insurance regulators to win a carve-out in business insurance liability policies so they are not obligated to cover AI-related workflows. “That kills the whole system,” Deeks said. Smiley added: “The question here is if it’s all so great, why are the insurance underwriters going to great lengths to prohibit coverage for these things? They’re generally pretty good at risk profiling.”

  • sp3ctr4l@lemmy.dbzer0.com
    link
    fedilink
    English
    arrow-up
    28
    ·
    1 day ago

    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.

    • artifex@piefed.social
      link
      fedilink
      English
      arrow-up
      11
      ·
      1 day ago

      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.

      • sp3ctr4l@lemmy.dbzer0.com
        link
        fedilink
        English
        arrow-up
        6
        ·
        edit-2
        1 day ago

        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.

    • Jacob_Mandarin@lemmy.world
      link
      fedilink
      English
      arrow-up
      7
      ·
      1 day ago

      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.

      • sp3ctr4l@lemmy.dbzer0.com
        link
        fedilink
        English
        arrow-up
        5
        ·
        edit-2
        1 day ago

        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.

      • yes_this_time@lemmy.world
        link
        fedilink
        English
        arrow-up
        2
        ·
        1 day ago

        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?

        • Jacob_Mandarin@lemmy.world
          link
          fedilink
          English
          arrow-up
          3
          ·
          1 day ago

          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.

          • yes_this_time@lemmy.world
            link
            fedilink
            English
            arrow-up
            1
            ·
            edit-2
            1 day ago

            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.