Do you really need foreign keys?

Re:Do you really need foreign keys? by Pet_Ant on Thursday December 21, 2023 @02:00PM (#38725091)

The _data_ yes, the _database_ no. The data will get migrated to different solutions at different times. I've lost track of how often I've been porting MySQL to SQL Server, SQL Server to Postgres, Postgres to Mongo, Mongo to cloud etc.

EDIT: fixed capitalization of "PostGres"

[ Parent | on HN ]

Re:Do you really need foreign keys? by winnebago on Thursday December 21, 2023 @02:40PM (#38725677)

This really depends on the size of your data set. If you have a large database (TBs+) it's likely to be very long-lived due the effort/hardware resources a migration requires - especially if you want to improve the schema when migrating.

[ Parent | on HN ]

Re:Do you really need foreign keys? by blowski on Thursday December 21, 2023 @05:37PM (#38728094)

I’ve seen a database migration project outlive application rewrites, multiple changes in CTO, and the company being acquired.

[ Parent | on HN ]

Re:Do you really need foreign keys? by jhardy54 on Thursday December 21, 2023 @02:58PM (#38725969)

Friendly suggestion: the conventional capitalization is either Postgres or PostgreSQL.

[ Parent | on HN ]