[throwaway27448]

How do they manage to get their sqlite database in such a state where it would need "repair"? how would psql fix this?

> or any real db

sqlite is literally the state of the art database. I suspect you mean "database server" or something

[gunalx]

I'm guessing incomplete migrations or similar problems where stuff is just partially written, or out of sync. The Plex db is kinda complex under the hood.