News for hackers. Stuff that matters.

A comment on Inside the longest Atlassian outage. Parent comment

Re:Inside the longest Atlassian outage by ollien on Wednesday April 13, 2022 @01:24PM (#31017435)
Gotcha. I guess you could be heavy-handed and disable foreign key checks, but who knows what other bugs that would bring into the mix.
[ Parent | on HN ]
Re:Inside the longest Atlassian outage by teling2 on Wednesday April 13, 2022 @03:19PM (#31018991)
The other difficulty is if you don't restore the entire state in a single transaction. Imagine you have partial data restored in Table A but haven't updated Table B correspondingly. Now some other program that consumes Table A and Table B and doesn't have error handling will crash (or worse, mutate state in other weird ways).
[ Parent | on HN ]
Re:Inside the longest Atlassian outage by jacquesm on Wednesday April 13, 2022 @03:27PM (#31019104)
That is relational integrity.
[ Parent | on HN ]