So many issues with SQLite and high volumes of data. It crashes so many times. We need PostgreSQL. Please.

Postgres, MySQL, MariaDB…just something. At the least, give us an option to set the cache_size in sqlite within Plex! I have over 20k files in Plex (video files, I’ve removed my audio library because performance reasons), and I can often see slowness during loading of the web client, or other clie…

something, anything. make plex database agnostic and work any standard sql database (local or remote).

TBH Switching from SQLite to anything else is not as easy as said. :slight_smile: The reason why sqlite is so much used is that doesn’t need an external dependencies, no extra daemon running only internal libraries dependencies and one file. With that i’m not saying that I wouldn’t like see Plex u…

It’s not that hard. If Plex would have been open-source I’d have forked it and done it myself.

Seems ridiculous to suggest that the support for other data storages is a hard task to implement, for sure it requires some work time, but the benefits that it brings are a lot. At least enough to get a response from some Plex team member that seems to ignore questions about this. I don’t think Plex…

I’d love to see them implement an ODBC compliant client for local or remote databases, with the default being the local SQLite since most people don’t need or want to mess with a database for their media server, but having the option there for those of us who would like it would be very helpful. I …

[image] tycoonbob: cache_size At the very least me too would like to have an advanced option for this somehow, somewhere. Just giving the SQL DB a bit more juice to work with can work wonders on larger systems and setups.

Glad to see more traction here. My libraries have grown to over 28k files as of today (compared to ~20k Jan 2019), which I’m sure has an impact on my SQLite DB. I’ve maintained my default_cache_size to be larger than my page_count, and it’s definitely been helpful. My page_count is ~56,000 as of …

I really think we need more momentum here. Even Chuck said it himself, that when talking to the database designer, sqlite was never expected to hold as much data as many of us have. Especially once we started adding large music libraries. We need more upvotes on this. Previously from Chuck: I p…

I don’t think we’re ever going to get this.

Switch from SQLite to PostgreSQL

Feature Suggestions

beckfield September 6, 2020, 9:02pm 15

There is already a feature request for this. Better to add your vote there than to split votes across multiple threads.

Topic		Replies	Views
[REQUEST] Move from SQLite to MySQL or Postgres Feature Suggestions	92	9339	June 11, 2022
Alternative database options Feature Suggestions	15	1078	September 7, 2020
Plex Media Server - SQLite - MySql Plex Media Server library-management	5	2000	September 6, 2020
Database Cache Size Behavior Question Plex Media Server server-freebsd	9	2286	January 12, 2023
Other DB options besides sqlite Feature Suggestions	0	102	June 27, 2023

Switch from SQLite to PostgreSQL

Related topics