Re:We do not use foreign keys (2016)
by andreimatei1 on Friday November 08, 2019 @04:12PM
(#21486827)
At GitHub they should be using CockroachDB (:P), a scalable relational database that also supports schema changes. Then their FKs would work just fine (albeit with some performance implications).
[ Parent
| on HN ]
Or, just not use FKs at all. There are many factors to consider when deciding on a DB, and being able to use FKs is probably not high on the list.
>being able to use FKs is probably not high on the list.
No, that's not at all probable. For many, "database" is synonymous with "ACID database", for which foreign keys are important. https://en.wikipedia.org/wiki/ACID#Consistency