Access PMS Database???

Dev Community Dev/API Corner
1

Hi

Does anyone know how to access the PMS database on a windows box??

I want to get, from an external app I wanna write:
Library name
Media Name
Sort Name
Cover Art location and file name
Media file location and filename

Any help would be appreciated.

Thanks
John

2

sorry - closed in error - re-opened

3

Yes this isn’t to hard. Check out the thread in my sig and look at the index on the op message. There are a few examples of how to access the database.

Carlo

4

@cayars

I looked.

Could not find anything that appears it would work for my needs.

I wanna write an external program where I can get the data described above to be used for an app I have in mind.

Thanks
John

5

U didn’t look good enough. :slight_smile:

You can use that technique to get the info you want. You’ll have to explore the field names you need. If you get stuck let me know and I’ll help you build it.

Carlo

6

Thanks!!

Help me understand how that would work using a PHP application. I wanna get the database info realtime in the PHP app so the website is always current and I do not need to run an external app to this thing.

John

7

OK then you want to go about it a different way. Instead of accessing the database directly (which you still can READ ONLY) you can use the Plex API to get this info.

You can find info and some 3rd party programs such as PlexPy https://forums.plex.tv/discussion/169591/plexpy-another-plex-monitoring-program/p1 in that section.

You may want to explore the code used in some of these programs as Plex isn’t the best documented API.