Piracy: ꜱᴀɪʟ ᴛʜᴇ ʜɪɢʜ ꜱᴇᴀꜱ

54577 readers

201 users here now

⚓ Dedicated to the discussion of digital piracy, including ethical problems and legal advancements.

Rules • Full Version

1. Posts must be related to the discussion of digital piracy

2. Don't request invites, trade, sell, or self-promote

3. Don't request or link to specific pirated titles, including DMs

4. Don't submit low-quality posts, be entitled, or harass others

Loot, Pillage, & Plunder

📜 c/Piracy Wiki (Community Edition):

💰 Please help cover server costs.


Ko-fi	Liberapay

founded 1 year ago

MODERATORS

[email protected]

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

submitted 10 months ago by [email protected] to c/[email protected]

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

[–] [email protected] 30 points 10 months ago* (last edited 10 months ago) (1 children)

Postgres in general is a considerably better db engine than SQLite in every metric except portability. Whenever you need more than a simple config storage, I heavily recommend using postgres. If it's good enough for gitlab, it's good enough for me.

[–] [email protected] 1 points 10 months ago (1 children)

I totally agree. I've been using it on and off since the 90's but I've never known that you can use it with the *arr apps.

[–] [email protected] 2 points 10 months ago

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