Whisparr is so much better with Postgres for its data back end (lemmynsfw.com)

submitted 10 months ago by Gimpydude@lemmynsfw.com to c/piracy@lemmy.dbzer0.com

8 comments fedilink hide all child comments

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.

you are viewing a single comment's thread
view the rest of the comments

[-] WetAndFlummoxed@lemmy.world 3 points 10 months 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.