Adding to the list: postgres (or any real db) support. I’ve had to repair their SQLite db so many times. It’s so common they have a help guide on it too and folks have made automated scripts to do it for you.

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

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.