News for hackers. Stuff that matters.

A comment on We do not use foreign keys (2016). Parent comment

Re:We do not use foreign keys (2016) by matt4077 on Friday November 08, 2019 @05:29PM (#21487601)
It's been a while, but IIRC at the time Rails got started MySQL actually did not even support foreign key constraints. Since that was the DBMS of choice, it wasn't much of choice.
[ Parent | on HN ]
Re:We do not use foreign keys (2016) by evanelias on Friday November 08, 2019 @05:52PM (#21487760)
InnoDB's foreign key support predates the existence of Rails by several years. However, InnoDB wasn't the default storage engine for MySQL at the time, so that may be a factor.
[ Parent | on HN ]
Re:We do not use foreign keys (2016) by DaiPlusPlus on Friday November 08, 2019 @10:07PM (#21489319)
I wonder how different the state of database application development would be today if all those cheap whitelabel webhosts powered by cPanel or Plesk (where most of us got started, I imagine) opted for PostgreSQL instead of MySQL - which would have influenced the major MySQL adopters like phpNuke, phpBB, WordPress, etc.
[ Parent | on HN ]