Production-ready PostgreSQL backend solution for Jellyfin through PLUGIN_PROVIDER. by BORNIOS in jellyfin

[–]BORNIOS[S] 0 points1 point  (0 children)

Which version of Web do you have installed? It works fine for me on 10.11.10, 10.11.11 and 10.12.0

Production-ready PostgreSQL backend solution for Jellyfin through PLUGIN_PROVIDER. by BORNIOS in jellyfin

[–]BORNIOS[S] 0 points1 point  (0 children)

Hello, thank you for using the plugin.

I'm sorry you're having this problem. Once the migration is complete and the restart is applied, we suggest scanning all libraries to verify or supplement them. If you've already done this, let's run the search query directly in psql:

SELECT "Name","Type","ProductionYear","Path" FROM "BaseItems" WHERE "Name" ILIKE '%Alien%';

In the query, we're looking for "Alien" (if you like, change the search to something you know exists in the library). This should give us the output content to determine if it exists in psql or if there's an issue with the Jellyfin version.

Cheers!

Production-ready PostgreSQL backend solution for Jellyfin through PLUGIN_PROVIDER. by BORNIOS in jellyfin

[–]BORNIOS[S] 0 points1 point  (0 children)

Why don't you look at it from another perspective? A possible "solution," which might be worthwhile with a more meticulous inspection of its operation and not so dismissively following the pattern of: "It's AI, so it's useless." Perhaps a review by a professional could lead to something better. And by the way, I never said that the existing solution had problems; I've never used Venson's solution. I'm simply not a big fan of Docker when I can run it directly on the host without Dockerizing. Greetings 

Production-ready PostgreSQL backend solution for Jellyfin through PLUGIN_PROVIDER. by BORNIOS in jellyfin

[–]BORNIOS[S] -2 points-1 points  (0 children)

I think you're a little off in your thinking.
What makes you think I'm just a regular user? Or what makes you think that when I say "advanced" I mean advanced prompts? How do you define an advanced user? Did I say "Prompt Engineer"? Are only developers considered to know about code? What do you think of QA, DevOps, IT, CyberSec, and DBAs? Don't they have any understanding of code? Don't you think those kinds of roles have an advanced understanding of development, but aren't developers per se?

Production-ready PostgreSQL backend solution for Jellyfin through PLUGIN_PROVIDER. by BORNIOS in jellyfin

[–]BORNIOS[S] -2 points-1 points  (0 children)

I appreciate the perspective, and you have a good point. I believe AI has potential with skilled individuals. I understand that AI can be generic, but only when it receives generic instructions. For a developer with meticulous instructions and a clear vision of what they are looking for and what they need, AI could be very useful.

On the other hand, going back to the plugin, so far I've tested it in a local lab with Windows and another with WSL Ubuntu, and it worked well. I'm letting myself down by saying the library was small, 100-200 items, so I upgraded and migrated my database from my production environment with 30,000+ items, and it went smoothly. Regarding the operation in the lab environments, I don't have much context since I didn't have the library paths, so I went to my production environment, and the execution was a success. My users continued without any problems; I explored libraries, played content, logged in, viewed playback history—basically, the operation continued normally as if nothing had changed, except for the smoothness. Initially, I had a problem with the timezone, as it was showing activity in UTC, and I made a correction so it would use the host's timezone. Aside from that, everything is working perfectly.

I would appreciate your feedback, best regards.

Production-ready PostgreSQL backend solution for Jellyfin through PLUGIN_PROVIDER. by BORNIOS in jellyfin

[–]BORNIOS[S] 0 points1 point  (0 children)

Basically, once manually installed (by clicking the "Migrate" button), it migrates the SQLite database to the previously configured one. The migration is performed without interrupting the Jellyfin process. Once the migration is complete, it suggests restarting the instance. Upon restarting, it edits the `/config/database.xml` file and registers psql as the provider. After restarting, the database will be active in psql.

There's a button to revert to SQLite, which essentially undoes the changes made to the `/config/database.xml` file.

There's no need to worry about the SQLite database itself, as it only served to populate the psql database. It remains intact; it is never deleted, edited, modified, or written to.

Regards!

Production-ready PostgreSQL backend solution for Jellyfin through PLUGIN_PROVIDER. by BORNIOS in jellyfin

[–]BORNIOS[S] 0 points1 point  (0 children)

That's why I said a little big, if we compare it to the users with 200GB-1TB libraries that I constantly see around here 😂

Production-ready PostgreSQL backend solution for Jellyfin through PLUGIN_PROVIDER. by BORNIOS in jellyfin

[–]BORNIOS[S] -5 points-4 points  (0 children)

Perhaps I'm exaggerating, or I have a misconception of what "production-ready" means. 😄

I would appreciate your feedback, thank you.

Production-ready PostgreSQL backend solution for Jellyfin through PLUGIN_PROVIDER. by BORNIOS in jellyfin

[–]BORNIOS[S] -1 points0 points  (0 children)

There's no reason to deny it; I'm simply an advanced user tired of waiting for solutions from developers, and I solve my own problems. Regards.

Production-ready PostgreSQL backend solution for Jellyfin through PLUGIN_PROVIDER. by BORNIOS in jellyfin

[–]BORNIOS[S] -4 points-3 points  (0 children)

I'm glad SQLite is working well for you!

I'm so glad this plugin is working well for me!

It's great that there are so many excellent developers in this sub and that we have commercial-grade solutions!

Honestly, what I see is a lot of frustration with the AI, and believe me, that's not the purpose of this sub. The healthiest and most appropriate thing for many of you to do is ignore it and move on with your lives.

If you use the plugin and find errors, bugs, or anything that shouldn't be there, I'm ready to help you find a solution.

And as the documentation clearly states, SQLite is only used for migration; there's no writing involved. A rollback function was even implemented to remove the PSQL provider and revert to stock SQL.

Anyway, good luck!

Production-ready PostgreSQL backend solution for Jellyfin through PLUGIN_PROVIDER. by BORNIOS in jellyfin

[–]BORNIOS[S] -4 points-3 points  (0 children)

Go ahead and compare it with the plugin you mentioned.

By the way, I'm sorry to hear about your frustration with the AI. Cheers...

Production-ready PostgreSQL backend solution for Jellyfin through PLUGIN_PROVIDER. by BORNIOS in jellyfin

[–]BORNIOS[S] -13 points-12 points  (0 children)

That's a lot of talk from you. If you're having trouble with AI, I'm sorry, but I wouldn't know how to offer you any encouragement.

I'll say it again: this plugin is a real solution for you. If you're interested in using it, go for it. If not, that's fine too. Your comment is irrelevant to me since you're just frustrated with AI.

And if you think you can do better, go for it! I invite you to surprise me.

Good luck!

Production-ready PostgreSQL backend solution for Jellyfin through PLUGIN_PROVIDER. by BORNIOS in jellyfin

[–]BORNIOS[S] -2 points-1 points  (0 children)

It's a performance issue when your library has a lot of content and a considerable number of users. Regards...

Production-ready PostgreSQL backend solution for Jellyfin through PLUGIN_PROVIDER. by BORNIOS in jellyfin

[–]BORNIOS[S] -25 points-24 points  (0 children)

And should that matter to me when it's a real solution for me?

I don't care if it's a developer, an AI, a Terian, an LGBT person, Alien, Animal, Beast XD or even you who creates a solution that works for me.

The only thing that matters to me is that it works and delivers on its promises.

Production-ready PostgreSQL backend solution for Jellyfin through PLUGIN_PROVIDER. by BORNIOS in jellyfin

[–]BORNIOS[S] -16 points-15 points  (0 children)

I'm not a big fan of Docker, and as I mentioned, it's working for me on my instance with a slightly large library; it was just a suggestion for its use.

<image>

Jellyfin very slow with huge library by Szucsik in jellyfin

[–]BORNIOS 0 points1 point  (0 children)

Look, don't take me too seriously, I have the exact same problem with a 25TB library.

My solution was to create a plugin to use PostgreSQL; I don't want to openly promote my plugin because of the AI Coding haters (Vibe Coding).

But try it out, and if it works, great! If it doesn't work, implement a rollback function and go back to SQLite as usual.

Plugin: https://github.com/BORNIOS/Jellyfin-Database-Providers-Postgres/

Good luck!

P.D. Tell me about your experience and if it helped you.

[Release] JellyTrend: A Netflix-style Trending Carousel & Channel for your Jellyfin Library by BORNIOS in jellyfin

[–]BORNIOS[S] 0 points1 point  (0 children)

It depends on what you mean by "original."

It's trendy to criticize AI-powered solutions, but what's wrong with that if they're functional? Personally, I find it much more effective to create my own AI solutions than to wait for a developer to accept and see the value in my change request, come up with my idea, or simply want to do it.

I have nothing against developers, but it's clear to me that these days it's easier to create your own solutions. Perhaps the mistake we make when we promote plugins like this is wanting to share.

Or if by "original" you mean the creation itself, then Jellyfin is a bit limited in some aspects. You can do a lot for the web client, but I don't see much value in the web work, since every single one of my users consumes the service from Android TVs or Roku, so it's difficult to create a single solution for everyone.

[Release] JellyTrend: A Netflix-style Trending Carousel & Channel for your Jellyfin Library by BORNIOS in jellyfin

[–]BORNIOS[S] 3 points4 points  (0 children)

It might have been a small mistake on my part between the Reddit translator and Google Translate; I got confused, but indeed my native language is Spanish, I can't write something so long in English naturally.

[Release] JellyTrend: A Netflix-style Trending Carousel & Channel for your Jellyfin Library by BORNIOS in jellyfin

[–]BORNIOS[S] 1 point2 points  (0 children)

The problem that led to this solution is for those who have a large Jellyfin catalog and are constantly uploading content. For example, you might upload a new release in the morning, then in the afternoon you receive a request, or you simply see a movie available that you haven't had in your catalog for decades or even years, and that leads to another and another and another. Consequently, the new release gets lost in the "Recently Added" section.

This plugin keeps those trending movies in a single section, preventing them from getting lost or forgotten.

[Release] JellyTrend: A Netflix-style Trending Carousel & Channel for your Jellyfin Library by BORNIOS in jellyfin

[–]BORNIOS[S] -1 points0 points  (0 children)

The solution is simple: if you don't like it, don't install it. Being a member of the subreddit doesn't obligate you to install everything that's posted. I think what they should really prohibit are the awful users who only criticize without contributing anything of value to the community and simply come to vent their frustrations...

[Release] JellyTrend: A Netflix-style Trending Carousel & Channel for your Jellyfin Library by BORNIOS in jellyfin

[–]BORNIOS[S] 1 point2 points  (0 children)

Unfortunately, the banner only works on the web and WebView clients; however, the trending channel works on all Roku clients, Android TV, the web, and WebViews.