# Plex mySQL watched status

**URL:** <https://forums.plex.tv/t/plex-mysql-watched-status/67638>\
**Category:** Dev/API Corner\
**Tags:** other-dev\
**Created:** [May 30, 2014, 6:05am UTC](https://forums.plex.tv/t/plex-mysql-watched-status/67638 "2014-05-30T06:05:00Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![OmgImAlexis](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/omgimalexis/32/285515_2.png) [@OmgImAlexis](https://forums.plex.tv/u/OmgImAlexis)\
**Post date:** [May 30, 2014, 6:05am UTC](https://forums.plex.tv/t/plex-mysql-watched-status/67638/1 "2014-05-30T06:05:00Z")

</div>

How hard would it be to have Plex use a MySQL&nbsp;server instead of&nbsp;SQLlite that it uses now?  
I'm specificly wanting to know about the watched state as I want to be able to access the data

outside of Plex and not have to back it up incase I have to move Plex or anything like that.

&nbsp;

I understand that XBMC allows you to use MySQL as an option in one of the preference files, does Plex still have that?

---

<div class="post-metadata">

**Author:** ![Moussa](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/moussa/32/314364_2.png) [@Moussa](https://forums.plex.tv/u/Moussa)\
**Post date:** [May 30, 2014, 6:23pm UTC](https://forums.plex.tv/t/plex-mysql-watched-status/67638/2 "2014-05-30T18:23:34Z")

</div>

To do it yourself? Pretty difficult I would guess. I imagine that Plex is pretty tightly coupled to SQLlite databases. But what’s stopping you from reading the SQLlite database anyway? You just can just download a viewer or query it as you would with a MySQL database.

---

<div class="post-metadata">

**Author:** ![OmgImAlexis](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/omgimalexis/32/285515_2.png) [@OmgImAlexis](https://forums.plex.tv/u/OmgImAlexis)\
**Post date:** [May 31, 2014, 12:18pm UTC](https://forums.plex.tv/t/plex-mysql-watched-status/67638/3 "2014-05-31T12:18:45Z")

</div>

> To do it yourself? Pretty difficult I would guess. I imagine that Plex is pretty tightly coupled to SQLlite databases. But what's stopping you from reading the SQLlite database anyway? You just can just download a viewer or query it as you would with a MySQL database.

Mainly I want to be able to have a MySQL server with my local Plex replicate to a remote MySQL DB to be able to do stuff with so I can't really use SQLite.

---

<div class="post-metadata">

**Author:** ![charlas](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/charlas/32/3634_2.png) [@charlas](https://forums.plex.tv/u/charlas)\
**Post date:** [January 24, 2015, 8:08pm UTC](https://forums.plex.tv/t/plex-mysql-watched-status/67638/4 "2015-01-24T20:08:13Z")

</div>

In the same boat, but would love it to be able to use MS SQL, but hey that's me ;)

---

<div class="post-metadata">

**Author:** ![mlocher75](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/mlocher75/32/13716_2.png) [@mlocher75](https://forums.plex.tv/u/mlocher75)\
**Post date:** [April 29, 2015, 1:09pm UTC](https://forums.plex.tv/t/plex-mysql-watched-status/67638/5 "2015-04-29T13:09:33Z")

</div>

Yeah, I can only agree. It is really a pity that they didn't use MySQL or any kind of server-based database.

This would allow much more flexibility for data extraction and/or editing with third party apps.

---

<div class="post-metadata">

**Author:** ![salsa2k](https://avatars.discourse-cdn.com/v4/letter/s/f475e1/32.png) [@salsa2k](https://forums.plex.tv/u/salsa2k)\
**Post date:** [April 30, 2015, 1:49pm UTC](https://forums.plex.tv/t/plex-mysql-watched-status/67638/6 "2015-04-30T13:49:40Z")

</div>

In my case I want something different.

I have a list with the movies filenames that I already watch.

I would like to know if is possible get this movies names and go to the database and mark as view.

Let's say I have in my list:

movie1.mp4

movie3.mp4

movie123.mp4

I want go to my user account and mark watched this files.

Anybody knows if is possible?

Thanks

---

<div class="post-metadata">

**Author:** ![cayars](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/cayars/32/6296_2.png) [@cayars](https://forums.plex.tv/u/cayars)\
**Post date:** [May 6, 2015, 2:45pm UTC](https://forums.plex.tv/t/plex-mysql-watched-status/67638/7 "2015-05-06T14:45:35Z")

</div>

I've longed to have this functionality myself. &nbsp;This would open up Plex to so many new 3rd party apps it's not even funny.

Right now even with proper tools like sqlite3 or programming libs to access sqlite there is the "locking errors/problems" and high chance of database corruption when accessing the DB while Plex is running.

Carlo

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\
**Post date:** [December 21, 2019, 2:12am UTC](https://forums.plex.tv/t/plex-mysql-watched-status/67638/8 "2019-12-21T02:12:11Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
