[Feature] - Use postgres as database

[RyuunosukeDS3]

I'd like to see wizarr have an option to use postgres as its database. For users using kubernetes this is a crucial feature.

[albinmedoc]

Why is this a crucial feature when using kubernetes?

SQLite should work without problems with as little data as wizarr saves.

[RyuunosukeDS3]

Cuz then I don't really need to have a persistent volume, I can just edit the config directly on my gitops solution and use Postgres as database.

[albinmedoc]

There are some things that cannot be saved in the database, such as uploaded files. They need to be saved on a persistent volume.

[RyuunosukeDS3]

That would be the case for people who actually use this feature. But then again they could make a persistent volume for that folder only, and also if we want to go a step further there are ways to save files in databases. Just need to enconde/decode it.

[SlothCroissant]

Why is this a crucial feature when using kubernetes?

SQLite is known to have file locking issues for network shares like NFS - not likely a huge problem for this service, since I assume the writes are pretty low-volume (so you are unlikely to have any collision issues where two writes are trying to happen quickly enough that the DB is locked), but it's possible.

This is also solved by using non-NFS persistentVolumes like Longhorn (iSCSI), etc.

I personally would love to see it since most of the *arr stack is now supporting Postgres, and Jellyfin itself is almost migrated to EFCore which will (in theory) unblock non-SQLite DBs via ORM.