Comment by dawnerd

5 hours ago

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.