At GitHub we do not use foreign keys, ever, anywhere

 收集于6个月前 阅读数 13
以下为 快照 页面,建议前往来源网站查看,会有更好的阅读体验。
原文链接: https://github.com/github/gh-ost/issues/331


Thanks for your hard work on gh-ost !

As I familiarize myself with the way it all works, I noted that foreign keys are explicitly not supported , but that they may be to some extent in the future.

Looking through issues in the repo, I also noted this expected feature that the table has neither foreign keys pointing to other tables, nor foreign keys pointing to it.

Could you please expand on your thoughs about foreign keys, and what you mean by “some extent” for their potential support? I am also curious: does this limitation mean that you don’t use foreign keys at all in GitHub’s MySQL databases, or do you use them and manage those tables somehow differently?

Thanks for your time and consideration!