Apple Photos app corrupts images

I’m a fan of the whole Apple ecosystem but I have to say that there’s a pattern here. Apple does a decent job of keeping my data safe from others but a terrible job of keeping it intact. From music libraries with song titles that got switched to long integers to this (and I’m sure more that I’m not remembering atm) they need to do a better job here.

Sure security is important but integrity is too.

I am baffled by Apple's incompetence here. In the past years I've seen:

* iTunes/Music app randomly reassign my Album artwork, with different (incorrect) art showing up on different devices!

* Reminders app: shared reminder lists can end up with the name of a different list

* Ghost photos that are deleted from my phone, and come back later.

* Maps, when I say "navigate to $friend" set a route that ended in my own driveway.

To me, these bugs suggest a fundamental design flaw, perhaps they are using a simple Integer as an index rather than a UUID?

Or maybe the database schema are solid, but there's some sort of race condition in their synchronization frameworks and the data is getting scrambled in RAM?

Whatever it is, it's absolutely insane that in 2025 these kinds of bugs are happening.