←back to thread

SQLite concurrency and why you should care about it

(jellyfin.org)
369 points HunOL | 4 comments | 01 Nov 25 12:59 UTC | HN request time: 0s | source
Show context
mangecoeur ◴[01 Nov 25 15:14 UTC] No.45782293[source]▶
Sqlite is a great bit of technology but sometimes I read articles like this and think, maybe they should have used postgres. I you don’t specifically need the “one file portability” aspect of sqlite, or its not embedded (in which case you shouldn’t have concurrency issues), Postgres is easy to get running and solves these problems.
replies(11): >>45782439 #>>45782829 #>>45782906 #>>45782930 #>>45782932 #>>45783524 #>>45784757 #>>45784918 #>>45787275 #>>45788143 #>>45788886 #
abound ◴[01 Nov 25 16:12 UTC] No.45782829[source]▶
Jellyfin is a self-hostable media server. If they "used Postgres", that means anyone who runs it needs Postgres. I think SQLite is the better choice for this kind of application, if one is going to choose a single database instead of some pluggable layer
replies(4): >>45783314 #>>45785817 #>>45786226 #>>45788638 #
1. npodbielski ◴[02 Nov 25 08:00 UTC] No.45788638[source]▶
What is the problem to bundle postgress db engine in the docker server? If you want to install it from package, they can have postgress dB as an option with the warning somewhere that it is 'recomended'. I am sure that if you are able to slefhost stuff you are able to install postgress too.
replies(2): >>45789054 #>>45789852 #
2. apitman ◴[02 Nov 25 09:40 UTC] No.45789054[source]▶
Jellyfin is one of the very few selfhosted apps that can be run as a simple GUI app on Windows. As an advocate for making selfhosting accessible to less technical people, I'm glad they're using sqlite and also that they don't require docker.
3. xorcist ◴[02 Nov 25 12:34 UTC] No.45789852[source]▶
A database is never hard to install, but it can be tricky to operate.

You have to at least have at least a slight idea about the specifics, from different types of vacuum to how it behaves in low memory conditions. The idea that docker has something to do this is a misdirection at best.

And if you think sqlite has many knobs and special modes, wait until you hear about Postgres.

replies(1): >>45791471 #
4. npodbielski ◴[02 Nov 25 16:31 UTC] No.45791471[source]▶
> And if you think sqlite has many knobs and special modes, wait until you hear about Postgres.

And why do you think I think that?