overseerr icon indicating copy to clipboard operation
overseerr copied to clipboard

feat: add support for PostgreSQL

Open zackhow opened this issue 2 years ago • 6 comments

Added support for postgresql.

Apologies if any of the formatting or conventions are wrong, this is the first time I have dipped into node/typescript.

ENVs for pgsql

  • DB_TYPE=postgres
  • DB_HOST=${ip/host}
  • DB_USER=${pg user}
  • DB_PASS=${pg pass}
  • DB_NAME=${db name} (defaults to 'overseerr')

zackhow avatar Jun 07 '23 21:06 zackhow

This pull request has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] avatar Aug 09 '23 23:08 stale[bot]

Any update on this? I'm having serious issues with sqlite once in awhile (DB gets corrupted) even when it's on local storage (not over nfs).

@zackhow is there a container built for this PR I can test with?

onedr0p avatar Jan 17 '24 17:01 onedr0p

Any update on this? I'm having serious issues with sqlite once in awhile (DB gets corrupted) even when it's on local storage (not over nfs).

@zackhow is there a container built for this PR I can test with?

There is ongoing work in Fallenbagel/jellyseerr#628 to achieve this, and containers available as well. Could probably be ported over here without too much effort, if there's any interest in merging this feature.

ralgar avatar Jan 23 '24 04:01 ralgar

I'll probably be migrating over to jellyseerr then. Nothing against the developers here (life happens) however it's a bummer this project doesn't have as much attention. It started out with such great momentum too. I hope sct can come back one day to focus on this project more.

onedr0p avatar Jan 23 '24 05:01 onedr0p

I'll probably be migrating over to jellyseerr then. Nothing against the developers here (life happens) however it's a bummer this project doesn't have as much attention. It started out with such great momentum too.

I hear you, it's the one problem with FOSS - hobby projects so often go stale. Jellyseerr has been great FWIW, but it looks to only be a one man show so it could easily suffer the same fate in the future.

ralgar avatar Jan 26 '24 03:01 ralgar

This pull request has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

stale[bot] avatar Apr 22 '24 08:04 stale[bot]