Live data from Hacker News

Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

github.com

61–70 of 756 posts

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#61

Why so much negativity? I find these projects interesting for learning purposes and exploring new ways. What’s wrong with that?

I don't really understand how "written by AI" and "for learning purposes" can ever be compatible. What exactly does one learn from typing "Rewrite this in Rust, make no mistakes" into a terminal?

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#62
post #55

Is this another llm-driven rewrite? I wonder how many "unsafe" blocks are in there...

From what I skimmed manually, not that many, but the code itself seems labyrinthical. Like, why have both Rust Try-supporting Error-like tagged union, but also booleans, for error handling, in the same function?

https://github.com/malisper/pgrust/blob/3646a73515a5e4ac7d0b...

https://github.com/malisper/pgrust/blob/3646a73515a5e4ac7d0b...

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#63

I start to see a lot of these re-writes that depend on tests to state that its working. But the things that make software like Postgres and SQLite reliable are not mostly the test, but the real world production scars. That's where the reliability comes from, years and years of running in production.

I agree. I also agree with the sibling reply that -

> every time you have a bug or a regression, you write a test that confirms correct behaviour.

What I fail to see in these rewrites however is - what about new bugs introduced by virtue of this rewrite? I mean it'll have to go through its own challenges in real-world scenarios, right?

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#64
post #33

Why should a developer use this for anything beyond a pet project? Just because it is written in Rust? All these "rewritten in rust" projects only reinforce the idea that a significant part of the rust community consists of software talibans and not of engineers who must deliver something that works and is reliable over time.

> software talibans

I will note that, very funny

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#65

I feel like we need to heavily differentiate between a rewrite and an AI rewrite.

It is more and more the future. No human would want to rewrite one technology to another because it is too marginal a gain. AI on the other hand does not give a shit.

You underestimate what people are willing to do just for fun.

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#66

Why so much negativity? I find these projects interesting for learning purposes and exploring new ways. What’s wrong with that?

I am concerned about the quality. Even a cursory skim of the code makes the code appear asinine. Unless the genius aspects of the code elude me.

https://github.com/malisper/pgrust/blob/3646a73515a5e4ac7d0b...

https://github.com/malisper/pgrust/blob/3646a73515a5e4ac7d0b...

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#67

Earlier quoted context omitted.

In a project like PostgreSQL, those scars are reflected in unit tests demonstrating that they’re fixed. It’d be hard to pass its test suite and not be as robust as the original.

They ought to, but are they? In https://wiki.postgresql.org/wiki/Developer_FAQ I don't see a requirement to provide a regression test for a bug fix.

It would be reasonably easy to audit and automate this...

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#68

I feel like we need to heavily differentiate between a rewrite and an AI rewrite.

Is there any measurable difference in quality between the two, or are you just going on "vibes"? Is there a correlation between the quality of the manually written code and AI generated code driven by the same dev? Such crude takes only cause unnecessary friction. If you have a black box that spits out code, and you are unable to distinguish the quality between a top tier dev and an AI inside the black box, then the…

> Is there a correlation between the quality of the manually written code and AI generated code driven by the same dev?

Aren't you making a strawman argument ? AFAIK this project is not made by an official PostgreSQL core developer, so the entire premise of your argument is invalid.

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#69
post #65

Earlier quoted context omitted.

It is more and more the future. No human would want to rewrite one technology to another because it is too marginal a gain. AI on the other hand does not give a shit.

You underestimate what people are willing to do just for fun.

Yeah like what do they think the people porting doom to everything possible are thinking?

Re: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests

#70
post #48

Earlier quoted context omitted.

AI is an average coder. It was trained on all code the code that could be found. Not just code written by genius programmers like Carmack and Bellard. Given that it's average, I'd prefer a human coder above average :)

You haven't been using AI extensively I presume... I've been programming a long time and considered myself among the top in my domain and AI agents using like GPT 5.5 etc. are much better than me.

> You haven't been using AI extensively I presume...

Ex falso quodlibet

> I've been programming a long time and considered myself among the top in my domain

I am not trying to attack you, but you considered yourself that... I don't know whether you actually were and frankly I don't care.

Post reply on HN