Live data from Hacker News

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

github.com

391–400 of 756 posts

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

#391
post #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?

How much token this would burn is of interest I suppose

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

#392

Earlier quoted context omitted.

Code is code. It either does the job or doesn't. If there is nothing that could convince you that AI generated code is trustworthy (for whatever definition of trust) then this is an article of faith, not a rational position.

> Code is code. It either does the job or doesn't. Surely that is not the only dimension that matters when evaluating software. Maintainability and readability, for example, are crucial for any long-lived project.

“Does the job” means all of those things. Figure out what’s important, find a way to measure it (could be also be qualitative.) How does the AI generated code do? If you simply say its no good because of the way it was created, it’s not a rational decision process.

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

#393

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

Possibly:

1. Piggybacking established brand names (Postgres + Rust)

2. … without practicality nor advancement (e.g. this solves no extra problems)

3. … without trust (i.e. LLM-driven rewrite, with no capabilities to thoroughly review it)

I think people get easily upset when the title has high-signal names like Postgres, and the title touts it somehow, yet it’s obviously impractical for obvious reasons (short-/long-term practicality, social trust & network effect, etc)

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

#394

Earlier quoted context omitted.

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…

Didn't the initial rewrite of Bun into Rust have an ocean of "unsafe" in it, and wasn't it entirely dysfunctional?

There's still no release of rust-bun so then it might just not exist (until it proves itself).

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

#395

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.

Great point. Stated another way:

"Mom, can I have battle-tested, reliable software"

"We have battle-tested, reliable software at home"

Battle-tested, reliable software at home: (Pic of green text from `cargo test`)

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

#396
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.

As someone who loves Rust the language and tool set: This class of projects [LLM rewrite of a reliable piece of software honed over decades) is embarrassing.

If you are watching this and haven't used rust: Please don't judge the language by this part of its users.

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

#397
post #296

Hey author here. Wasn't expecting to see this up. To concisely give an overview of the project, I've been experimenting with using LLMs to build a better version of Postgres. Postgres is 30 years old and we've learned a lot about databases since hten. A lot of the techniques that work for doing a rewrite are also useful for doing a rearchitecture. I'm now working on a new, not yet published version of pgrust that inc…

Ouf. I don't know. I don't want to call you out without evidence -- I myself make benchmark claims all the time -- but 50% improvement in OLTP seems suspicious. I get that you used a standard benchmark, and I don't even know what it entails, but my spidey sense is going off. Perhaps, some trade off somewhere that won't make it to prod because it breaks MVCC -- and yes, I saw that it passes regression tests. Just chec…

It'd be very unfortunate if Postgres didn't have regression tests for data loss due to bad io patterns. Should be possible to do some checks against those in an appropriate test harness. Which might mean "have qemu run something we can kill off and examine the results".

If those don't exist, I hope folks recognize how useful they are and add them.

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

#398
post #216

I suspect the future of open source will be to never publish your tests. Or someone will just pump them into an LLM like this.

SQLite already does this but hasn’t stopped the rust /go clones from popping up .

These are toy projects with no serious interest in maintaining the port long term. and even with things like bun where the port is merged it remains to be seen on maintainability over time.

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

#399
post #374

Earlier quoted context omitted.

What about extensions that are not sketchy? Lots of good ones out there.

Presumably they'd be fine running in a threaded context.

Extensions like pgvector, TimescaleDB would probably need to be ported tho, not sure how much but there are footguns.

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

#400
post #372

Earlier quoted context omitted.

A mixture of threads and processes that can be used to match processors, disk I/O, and network interfaces. A very long time ago, there was once a feature called "Data Blades" which tanked a commercial database vendor. A badly behaving blade could bring down the entire database. Most anyone who has been working on databases for a few decades remembers this and makes a point of either not introducing these sorts of fea…

> A very long time ago, there was once a feature called "Data Blades" which tanked a commercial database vendor. I have no idea what this is and a web search turned up Harbor Freight woodworking tools.

I think it's this: https://www.ibm.com/docs/en/informix-servers/15.0.x?topic=co...

And what you found seems to be "Dado", not "Data".

Post reply on HN