You don't need a service as big as GitHub; you just need billions of rows. I thi... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		barrkel on Nov 8, 2019 \| parent \| context \| favorite \| on: We do not use foreign keys (2016) You don't need a service as big as GitHub; you just need billions of rows. I think you should enable FKs for test and dev, and possibly QA, but disable them in production. Depending on your database, you'll get surprising interference in concurrent operations via other means than FKs, but FKs don't help.

davidw on Nov 9, 2019 [–]

"Just" need a billion rows.

Sure, some people get there, but it makes sense to do things the right way first, then figure out how to cut corners only when and if you need to.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact