Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature Request] Add support for external database connections #186

Open
1 task done
mari-arondeus opened this issue Jul 17, 2022 · 3 comments · May be fixed by #628
Open
1 task done

[Feature Request] Add support for external database connections #186

mari-arondeus opened this issue Jul 17, 2022 · 3 comments · May be fixed by #628
Labels
enhancement New feature or request

Comments

@mari-arondeus
Copy link

Description

I'd love to be able to connect Jellyseerr to an external MySQL or Postgres-compatible database to allow for sharding, replication, and HA deployments. Currently Jellyseerr (and Overseerr) uses an internal SQLite database for request storage.

Desired Behavior

Ideally, I'd like for there to be a set of environment variables that can be set in order to configure and use an external database connection. That way, the default (with no variables set) would be SQLite and no functionality is broken or removed for simple deployments like this. If the user so desires, they would be able to enable and configure the database, significantly expanding deployment options.

Additional Context

No response

Code of Conduct

  • I agree to follow Overseerr's Code of Conduct
@teambvd
Copy link

teambvd commented Aug 2, 2022

+1 to this, and it's pretty important for my usecase. With kubernetes becoming less and less niche for those running servers at home, something with better support of the features necessary to run fully HA is highly desirable.

Additional, and from the performance angle this time, between movies, tv, and audio, I'm at nearly ~75k items:

root@<mahServer>:/mnt/user/media# find music -type f | wc -l
38802
root@<mahServer>:/mnt/user/media# find movies/ -type f | wc -l
2475
root@<mahServer>:/mnt/user/media# find tv_shows/ -type f | wc -l
31867

I've tuned the individual media management's SQLite DB's to the limited extent possible and that's helped them in the past (20k-ish items), but am once again starting to see slight sluggishness creep back in again. While Jellyseerr has far less transactional history to handle (e.g. no activity log for trying the same media object 60 different times, so far less history to parse), between them I feel hitting some boundaries are inevitable.

Fan-friggin-tastic work on JellySeerr! I'm opening up a feature request here shortly to ask for a donation link - need some kind of way to support y'all!

@Fallenbagel Fallenbagel added the enhancement New feature or request label Aug 3, 2022
@aleksasiriski
Copy link
Contributor

I made a duplicate on Overseerr, most likely if this is going to happen it should be made upstream, since Jellyseerr is a fork.

[Feature Request] Add support for external database connections #3176

@teambvd
Copy link

teambvd commented Dec 26, 2022

I made a duplicate on Overseerr, most likely if this is going to happen it should be made upstream, since Jellyseerr is a fork.

[Feature Request] Add support for external database connections #3176

The main reason for asking here is that it's been requested several times already there, and appears (at least based on the amount of activity on them) that there's possibly little appetite for it. There's this discussion dating back to 2020, where I'd actually asked if the PO would be open to letting us 'directly fund / pay for' the feature, though no feedback up to now. They may be super busy, or maybe they just don't feel it fits with their vision for the application, but either way, it's at least been brought up.

There's also this pr where someone has attempted to at least get the ball rolling.

Given this fork's goals have been aimed at broadening the scope of the base overseerr project, perhaps they'll pick up the mantle. I understand it's potentially quite the undertaking, but my hope is that, given this note back in 2020 stating that it was technically already possible at that point and just hasn't been exposed, it may not be too big of a lift to bring it in over here. Keeping my fingers crossed regardless!

dr-carrot added a commit to dr-carrot/jellyseerr that referenced this issue Jan 19, 2024
@dr-carrot dr-carrot linked a pull request Jan 19, 2024 that will close this issue
7 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants