# \[REQUEST\] Move from SQLite to MySQL or Postgres

**URL:** <https://forums.plex.tv/t/request-move-from-sqlite-to-mysql-or-postgres/78346>\
**Category:** Feature Suggestions\
**Created:** [October 4, 2014, 9:06pm UTC](https://forums.plex.tv/t/request-move-from-sqlite-to-mysql-or-postgres/78346 "2014-10-04T21:06:28Z")\
**Posts on this page:** 1\
**Showing post:** 13

<div class="post-metadata">

**Author:** ![Ryushin](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ryushin/32/4494_2.png) [@Ryushin](https://forums.plex.tv/u/Ryushin)\
**Post date:** [January 24, 2020, 3:02pm UTC](https://forums.plex.tv/t/request-move-from-sqlite-to-mysql-or-postgres/78346/13 "2020-01-24T15:02:06Z")

</div>

This needs to be raised as a priority. Almost every project that I use, such as Nextcloud, BareOS, SpamAssassin, Amavis, RoundCube, Icinga2, etc, offers the option to use SQL database, such as SQLite, MariaDB/MySQL, PostgreSQL… Plex is database heavy and to not have the option to use a proper database is just wrong.

I’m having constant slow queries against SQLite3 and so are many others if you read the Plex reddit. This really only seems to affect large Plex installations. I’ve spent a large amount of time trying to optimize SQLite and I don’t feel I can take it any further. The only solution I’ve read to fix the slow queries is to the database on a RAM drives. SSD is not fast enough and I have a six drive SSD ZFS system with 32GB of cache.  
Please see:

> [@Slow Database](https://forums.plex.tv/t/slow-database/529651):
>
> So I’ve been working on issues with my slow queries with my Plex database. I don’t have any kind of corruption. System Information: Running ZFSonLinux 0.8.2. My root pool which also has /var/lib/plexmediaserver dataset on it consists of six 2TB WD Red SA500 SSDs in a raidz2 (think raid6) configuration sitting behind a LSI SAS3 controller. System has 64GB of ram and 32GB is allocated to ZFS ARC (cache). The ZFS plexmediaserver dataset has a recordsize of 16K, atime=off, compression=lz4. In…

What will it take to get the Plex Devs to start prioritizing issues like this. I can understand Plex trying to monetize it’s product but you need to take care of your core users. Users who host their own data on their own servers.

---

_[View the full topic](https://forums.plex.tv/t/request-move-from-sqlite-to-mysql-or-postgres/78346)._
