Live data from Hacker News

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

github.com

621–630 of 756 posts

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

#621

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

Because it's a waste of token.

I'd love to be proven wrong, but chances are that nobody will use this in production, people will completely forget about the project in 6 months, and the project will be archived not long after that.

This is not the first one of similar projects.

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

#622
post #548

Earlier quoted context omitted.

There are hundreds of comment chains about this already, go troll somewhere else.

If you’re going to make a confident blanket claim, be ready to back it up - and asking for clarification is not trolling, by the way. You should be ready to engage in technical conversations if you want to make technical claims.

I'm not interested in a technical conversation with you; I was answering someone else. The top voted comment thread of this page, which dominates discussion, already covers everything you'd want to know.

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

#623

Setting aside the “why” that everyone is so focused on, I want to know, how? I can’t get Claude to do anything even a fraction of this complexity. How are people setting up their agents, Claude.md, etc to do such big projects? There are a lot of lessons to be learned.

> I can’t get Claude to do anything even a fraction of this complexity.

I remember writing a postgresql compatible DB with Opus 4.5, that used S3 as storage and local caching to make it speedy.

Ironically, Opus 4.5 is by todays standards is antique. If you have some knowledge about Databases, it goes a long way.

But you need to do it step by step. Getting the core to work, getting a Pratt parsing going. The whole pgwire protocol ... the data format ...

Step by step ...

With todays Models, your can probably get away with using /goal and telling it to make a postgresql compatible database, while having it run a few days.

Now, making a fun database test project and having it production ready! Big difference!

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

#624
post #560
post #78

How would one go about reviewing a piece of code like this? One of the things I'd typically do is peek at the commit history. Seeing what people worked on and how they did it tends to say a lot about a project. But with LLMs generating 7101 commits in less than a month that isn't feasible. Even looking at a single day is way too much [1]. It probably also doesn't make sense since the commits content won't tell you mu…

I started by looking at the dependencies. Then I lost count, so I ran wc -l Cargo.lock 1467 Cargo.lock Easily over a thousand dependencies. And "rewritten in Rust" is supposed to be a good thing? I bet this doesn't even compile faster than the original.

Disaster. Well, I read stories about Rust and how there isn't much in the stdlib, but this is just too much. How many dependencies are there, on average, in other projects? I guess I am spoiled with Go.

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

#625
post #351

Earlier quoted context omitted.

It’s open source. You take ownership of it for your deployment and stop relying on continued free work. You can use llm to pull in updates as they are released. It’s not gpl, so you don’t need to publish your port

1. Nobody, not even the Googles or NSAs of the world do that. No single entity has the expertise nor resources necessary to maintain a fork for every open source project they use -- forking and maintaining Linux alone takes teams of people. And no, going full psychosis mode with LLMs is not going to save you. 2. This project is AGPLv3.

Forking and maintaining Linux does not take teams of people. I've been at it for > 10 years and maintained support for my 15 or so various SBCs/mobile devices, writing drivers, debugging, cleaning things up. It's a weekend project every 3 months + whatever you want to put in for development.

And there are others doing it for projects like Armbian, openwrt, etc.

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

#626
If you can do a Rust rewrite with AI, I can create one as well. What makes yours better than mine? Your decade long expertise in database or Rust language? Your reputation? Your proven track record to manage large, complex projects? Your time committed to the project? I don't see any of that.

I don't know why anyone would choose this over the actively (community) maintained proper Postgres project.

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

#627
post #303

Earlier quoted context omitted.

If it's a choice between performance and being able to "safely" run sketchy extensions, I'd rather have performance.

Threads does not offer any major performance advantage, performance of processes vs threads is virtually the same. The reason the PostgreSQL project is moving towards threads is to make development easier.

MSSQL can handle 32k open connections no need to run a pooler in front of it, can PG do 32k connections and a process for each?

MSSQL shares cached query plans between connections including jitted code, PG cannot do that and the changes needed to make the plans cross process portable would be extensive while sharing between threads is just normal code sharing between threads.

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

#628
post #560
post #78

How would one go about reviewing a piece of code like this? One of the things I'd typically do is peek at the commit history. Seeing what people worked on and how they did it tends to say a lot about a project. But with LLMs generating 7101 commits in less than a month that isn't feasible. Even looking at a single day is way too much [1]. It probably also doesn't make sense since the commits content won't tell you mu…

I started by looking at the dependencies. Then I lost count, so I ran wc -l Cargo.lock 1467 Cargo.lock Easily over a thousand dependencies. And "rewritten in Rust" is supposed to be a good thing? I bet this doesn't even compile faster than the original.

The naysaying here is insane. Should a project like this not exist?

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

#629
post #626

If you can do a Rust rewrite with AI, I can create one as well. What makes yours better than mine? Your decade long expertise in database or Rust language? Your reputation? Your proven track record to manage large, complex projects? Your time committed to the project? I don't see any of that. I don't know why anyone would choose this over the actively (community) maintained proper Postgres project.

Came here to the same thing. I did something similar (but bolder, it doesn't slavishly copy Postgres and is based on current DB research papers and the like, and other bits I've been exposed to over the years). It has a full TPC-C-esque benchmark suite, replication, embedded v8/JavaScript relations/stored procedures, a giant suite of regression tests, it kicks the crap out of a lot of existing OLTP DB stuff out there. And I personally do have a background in commercial DB development.

But I choose not to publish it or promote it for many of the reasons you mention above (and more)

... For one, if "I" can do it, so can a hundred other people. And all the bold claims behind it would need to be backed up and supported and it promoted, etc, which is a whole pile of time that doesn't involve writing code.

It's the organization around a project that matters, not the code. It's not the 90s anymore w/ people piling into MySQL because it was the only option. People aren't going to be trusting your software with their data, if they can't trust you.

And unless someone is going to dump a pile of money or something on [me|them], I don't have the ability to build that organization ... as I need to feed my family... Nor am I willing to put my personal reputation on the line by putting up a huge quickly written application and then someone finding something in it I can't explain.

So like probably 500 other projects I have it sitting in a private repo.

It's a very weird time right now. "Technical" excellence isn't the important part. Organizational excellence is. This was always the case but it's more so now.

... In the meantime, if anybody has angel investment to burn, I have something potentially better/more-exciting than this guy's project but... see above...

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

#630

Earlier quoted context omitted.

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).

Yesterday we learned that it’s been shipping with Claude Code since mid June, so it has a lot of active users already.

Also, the unsafe footprint seems reasonable — the bulk of it in FFI wrappers.

Post reply on HN