Re:PHP 3.0 Final is out (1998)
by dspillett on Monday May 24, 2021 @09:18AM
(#27263992)
I see your point for decentralised systems, "eventual consistency" is an unavoidable evil in many cases there at least if you don't want a performance hole caused by distributed transaction requirements.
But otherwise, I disagree strongly.
> feigned idea about data integrity but it's mostly bullshit
I call BS on your call of BS.
> The other common situation is...
If that is common in your production environments, then I never want to work with your production environments.
> foreign keys just get in the way.
Disable them, do the jiggery-pokery, and then replace them. Again, but not in production systems.
If FKs are an inconvenience day-to-day then you have something seriously wrong somewhere. They are protection against bugs and other unpredictables causing corruption of data that other code later relied upon being correct.
But otherwise, I disagree strongly.
> feigned idea about data integrity but it's mostly bullshit
I call BS on your call of BS.
> The other common situation is...
If that is common in your production environments, then I never want to work with your production environments.
> foreign keys just get in the way.
Disable them, do the jiggery-pokery, and then replace them. Again, but not in production systems.
If FKs are an inconvenience day-to-day then you have something seriously wrong somewhere. They are protection against bugs and other unpredictables causing corruption of data that other code later relied upon being correct.