How hard would it be to have Plex use a MySQL server instead of 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.
I understand that XBMC allows you to use MySQL as an option in one of the preference files, does Plex still have that?
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.
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.
In the same boat, but would love it to be able to use MS SQL, but hey that's me ;)
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.
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
I've longed to have this functionality myself. 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
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
