I have a library of videos that I've downloaded with whisparr running in a docker container. I've had a problem with the sqlite DB getting corrupted on a daily basis. I followed the guide on switching to postgres and it only took about 15 minutes, including setting up a postgres server. I really recommend anyone running it to do that. There's been a noticeable performance boost too.

top 5 comments

sorted by: hot top controversial new old

[–] UntouchedWagons@lemmy.ca 7 points 2 years ago (2 children)

I had the same experience with some of the 'arr projects.

[–] pete_the_cat@lemmy.world 2 points 2 years ago

Interesting, I didn't know you could migrate the other 'arr projects to postgres. Definitely gonna attempt this later tonight.

[–] Gimpydude@lemmynsfw.com 1 points 2 years ago

I'm going to move my others to postgres as well. It's dead simple and so much better.

[–] Gorusnor@lemmy.dbzer0.com 3 points 2 years ago

Just set up my arr apps to use rdtc on a 500gb VirtualBox Linux machine and I love it, I'll keep this in mind when adding whisparr ty

[–] WetAndFlummoxed@lemmy.world 2 points 2 years ago

I had trouble with the sqlite databases when I was writing them to a remote volume over nfs. I've had zero issues since moving them to local disk and performance is great.