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 think it’s a relatively recent thing. As the documentation for each of the *arts has a relatively recent minimum version number I think.
Here’s where I went when looking for whisparr, but just replace that with the arr you’re wanting to use and it’ll give you decent steps for getting your database created and migrated into it: https://wiki.servarr.com/whisparr/postgres-setup