Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Neki – Sharded Postgres by the team behind Vitess

planetscale.com

Post reply on HN
Print view View original

21–30 of 43 posts

Re: Neki – Sharded Postgres by the team behind Vitess

#21

Post by bddicken »

benjiro wrote: post #20
atombender wrote: post #12

This is exciting. The announcement says it will be open source. I really hope that this includes a functionally complete control plane so you realistically self-host. I looked Neon recently, and it appears that it's designed as a SaaS product from the outset; while it is technically possible to self-host the individual components of the architecture, it does not look trivial, in large part because the control plane i…

Your probably better off with the original flavor (the guy that made Vitesse) https://multigres.com/ He is making a open source version of porting Vitesse to Postgres.

Why? Neki is built by the the engineers who have built, maintain, and operate massive-scale Vitess databases.

Re: Neki – Sharded Postgres by the team behind Vitess

#22

Post by Reubend »

Very cool, and I'm looking forward to using this. But unfortunately it seems like it's not actually released yet?

I'm a little surprised to hear that PlanetScale is doing the work to make this considering I thought their entire system was based on Vitess. Maybe the demand for Postgres compatible DBs is so high nowadays that they need to offer compatibility for customers that don't want to port their apps to MySQL's syntax?

Re: Neki – Sharded Postgres by the team behind Vitess

#23

Post by kelp »

bddicken wrote: post #21
benjiro wrote: post #20

Earlier quoted context omitted.

Your probably better off with the original flavor (the guy that made Vitesse) https://multigres.com/ He is making a open source version of porting Vitesse to Postgres.

Why? Neki is built by the the engineers who have built, maintain, and operate massive-scale Vitess databases.

To add to this, if you look at the top 10 committers to Vitess over the last 12 months, 8 of them are helping with Neki in one way or another:

https://github.com/vitessio/vitess/graphs/contributors?from=...

Re: Neki – Sharded Postgres by the team behind Vitess

#25

Post by n_u »

rockwotj wrote: post #16
hubertzhang wrote: post #7

Does Neki still need sharding key in query, just like Citus?

If it’s like vitess then no, but IIRC you get relaxed consistency across shards

Regarding cross-shard consistency, there's a doc here[1] on the options. In short you can just send the writes to all replicas, you can disallow cross-replica transactions (read and write), use two-phase commit to perform a distributed transaction or use their own hybrid approach that they set as the default.

[1] https://vitess.io/docs/20.0/user-guides/configuration-advanc...

Re: Neki – Sharded Postgres by the team behind Vitess

#27

Post by gethly »

ozgrakkurt wrote: post #9

Is anyone working on replacing postgres? Feels like it might be very useful since a lot of new technologies came out since spinning disks.

> Feels like it might be very useful since a lot of new technologies came out since spinning disks.

The MVCC that Postgres uses(and no one else) is like 50yo outdated concept they still cling to. So just by virtue of that, it makes PGSQL the most archaic db on the market nowadays.

I never understood why PGSQL had so many fanboys, yet every major tech company always ditches it for mysql... i guess it is the case of "Any man who must say, "I am the King", is no true king." type of thing. People have to make a lot of noise to excuse their bad choices so they don't have to admit making a mistake.

Re: Neki – Sharded Postgres by the team behind Vitess

#28

Post by erpellan »

gethly wrote: post #27
ozgrakkurt wrote: post #9

Is anyone working on replacing postgres? Feels like it might be very useful since a lot of new technologies came out since spinning disks.

> Feels like it might be very useful since a lot of new technologies came out since spinning disks. The MVCC that Postgres uses(and no one else) is like 50yo outdated concept they still cling to. So just by virtue of that, it makes PGSQL the most archaic db on the market nowadays. I never understood why PGSQL had so many fanboys, yet every major tech company always ditches it for mysql... i guess it is the case of "A…

I can’t believe they still make processors out of sand. Talk about outdated technology.

Sarcasm aside, a great many projects started on MySQL and moved to postgres. As did projects using mongo, couchdb, firebase, oracle etc etc…

And I’m sure many projects switched away from Postgres to other technologies. Right tool for the job at hand.

Re: Neki – Sharded Postgres by the team behind Vitess

#29

Post by tpetry »

purpleidea wrote: post #19

Maybe make the announcement after you've actually released code? Today I'm announcing I've cured cancer. Well not yet, but coming soon hopefully!

More like: We‘re announcing to work on a cure in cancer! Isn‘t that aweslme? No, we dont have anything yet. But we started working on it. ETA? When its done. We dont share roadmaps with outsiders.

Re: Neki – Sharded Postgres by the team behind Vitess

#30

Post by zozbot234 »

erpellan wrote: post #10
ozgrakkurt wrote: post #9

Is anyone working on replacing postgres? Feels like it might be very useful since a lot of new technologies came out since spinning disks.

If you look at the changes that have been made to Postgres, and continue to be made, the answer is yes. The Postgres team is working on replacing Postgres. With even better Postgres.

inb4 "It's the best Postgres we've ever made!"
Post reply on HN