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.
I had the same experience with some of the 'arr projects.
Interesting, I didn’t know you could migrate the other 'arr projects to postgres. Definitely gonna attempt this later tonight.
I’m going to move my others to postgres as well. It’s dead simple and so much better.
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.
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
