undefined | Better HN

0 pointsAYBABTME2y ago0 comments

The Venn diagram of people needing sharding and still using foreign keys is probably empty.

0 comments

Worth noting, the competing products from Neon and Cockroach Labs support FKs.

Cockroach supports it, but like for MySQL, PG, PlanetScale, or most DBs at scale, you shouldn't use them.

Neon isn't in the same league at all so I think what they support doesn't matter.

> but like for MySQL, PG, PlanetScale, or most DBs at scale, you shouldn't use them.

Tell that to the people who have been successfully building massive databases in RDBMS for decades making extensive use of FKs and FK constraints.

Neon is not a shared nothing architecture but shared storage. Makes it 100% compatible with Postgres that supports FK constraints since 1989

Also would be useful to add a disclaimer that you work for PlanetScale.

j / k navigate · click thread line to collapse