zr0

I just checked the code and unfortunately, they do not support loading the SQLite file into memory yet. Even worse, the change would be substantially. It appears they currently abuse the database connection a bit. They basically create a new connection for each operation. This does not matter if you can read/write in parallel, but that’s only the case with NVMe and certain drivers. So all SATA (SSD and HDD) suffer from the current mechanic. So just loading it into memory is not going to solve the issue. Jellyfin needs to change architecturally, so that a database connection is reused. I don’t know why or who implemented the current logic, but it is clearly done by someone not understanding how databases work.

Depending on the mood and time, I will come up with a solution that is solid. For now, you are stuck with the current logic.

How large is the database? Because there is a way to fully load SQLite into memory, which would speed everything up drastically for a scan. At the end of the scan, you could just write back everything to the disk, then it is just one blob of sequential write, which is fast enough on spinning rust.

FYI: they use Claude Code.

Just in case anyone has an issue with that.

We could also make the people behind that very famous. Don’t hide their names. Give them more attention.

oasiscm.com/about-us/

I had long discussions with some mailcow contributors and it turns out, that some default settings can lead to an open relay if you are not careful. The biggest problem is that they use postfix. Postfix is not bad itself, as it is probably the most battle tested mail server. The configuration of postfix is a different story. And even if I prefer battle tested GNU/BSD software, postfix would be one of the rare exceptions where I would be careful.

I had a postfix running for years without issues, when I self-hosted SimpleLogin, and I fully agree with you. Once it runs, you only need to make sure that the security is managed.

I used mailcow, got an open relay immediately. Stalwart seems to do things a bit better.

I host so many services and it is not that I don’t want to learn new stuff. The effort is simply too high for a single service. And since there are very good providers which fully encrypt your data, I went this route to keep my mind off this part of my system.

One wrong config entry, and you have an open relay and a domain that can never be used for SMTP again, yay.

Actually managing an email server properly is demanding, as it is one of the most attacked services. Of course, you can also take the easy route and just pray.

I had the same thought. No real wooden joints, just pure screws and some prayers. This will probably not withstand winds above 80km/h

You know, next time you could just put them on a roof.

Mutants!

Jellyfin people who constantly ask “have you tried Jellyfin?” have never used Plex and don’t know what they are missing out on.

I have Emby lifetime. I have Plex lifetime. I try Jellyfin every year.

Plex wins always. Emby is second. Would not recommend Jellyfin.

And 46% have no idea what a database is.