Database type and file location

General Discussions
1

Hi. What is the database type (and can it be converted to an MS Access, Excel, or txt file format for manipulation?) and what is the Windows file explorer path to the database location?

Thanks,
ttrenchj

1 Like
2

SQLite

no

https://support.plex.tv/hc/en-us/articles/201100678-Repair-a-Corrupt-Database

3

@OttoKerner said:
SQLite

no

https://support.plex.tv/hc/en-us/articles/201100678-Repair-a-Corrupt-Database

@OttoKerner: I’m not familiar with SQLite specifically. Would I be able to modify the com.plexapp.plugins.library.db using SQLite?

4

In theory, yes.
But you need to know how the tables in the DB interact with each other, or you may bring your db into an inconsistent state.

I advise you to check out this tool and its source code to get some insight:

and maybe this thread as well:

5

@OttoKerner said:
In theory, yes.
But you need to know how the tables in the DB interact with each other, or you may bring your db into an inconsistent state.

I advise you to check out this tool and its source code to get some insight:
https://forums.plex.tv/discussion/120292/moviefans-database-tool-for-plex/p1#top

and maybe this thread as well:
https://forums.plex.tv/discussion/comment/1080551/#Comment_1080551

@OttoKerner: Thank you.