Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
Hamuko
on Nov 8, 2019
|
parent
|
context
|
favorite
| on:
We do not use foreign keys (2016)
I'm gonna wager a guess and say that most MySQL users do use foreign keys without a problem. Most MySQL users are not running Github scale.
fdr
on Nov 8, 2019
|
next
[–]
That's probably true. The only tell for that, really, was the complexity around migrations/schema changes, which seems a lot more painful on MySQL.
cryptonector
on Nov 8, 2019
|
parent
|
next
[–]
I don't understand why anyone would choose MySQL over PG, honestly.
jeltz
on Nov 9, 2019
|
prev
[–]
True, but the people I know who run PostgreSQL at that scale do not complain about foreign keys. Not since PostgreSQL added separate lock levels to improve concurrency with foreign keys.
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search: