Re:We do not use foreign keys (2016)
by dkhenry on Friday November 08, 2019 @05:57PM
(#21487800)
This really makes it seem like you have never used a database system at scale. There are reasons why systems like MySQL let you turn them off, and they are some of the same reasons why pretty much everyone who uses a database at scale has settled on MySQL. Also its why as is mentioned in the issue once you actually scale your database foreign keys become a nightmare. If all you have is a toy project you can feel free to use any database you want, but if you actually need to serve traffic you might want to rethink your priorities.
[ Parent
| on HN ]
> everyone who uses a database at scale has settled on MySQL
hmm?
I've only every seen people using MySQL at scale if they started with MySQL in prototype and never had the energy to migrate.
Well here is one case of a large scale user migrating
https://eng.uber.com/mysql-migration/
And there are tons more. In fact here is a tool to help you do it
Re:We do not use foreign keys (2016)
by spookthesunset on Friday November 08, 2019 @06:55PM
(#21488272)
Uber also has a giant team dedicated to re-inventing slack. I'd take their engineering prowess with a grain of salt.
Lots of people do dumb things for dumb reasons.
Most developers I interact with, even the really good ones, are profoundly stupid when it comes to databases.