Is it possible, upon completion of a fresh Plex install, to end Plex and then run an SQL statement that would in effect fully automate adding a media library? Basically the statement would insert into the proper table(s) the media type, and the path to appropriate media. Then upon restarting Plex, it would scan and detect the changes, and go and do its thing. The reason I ask is that I fully scripted a fresh install of my Ubuntu box, and about the only thing missing is this capability. Thanks!
That’s not something which can be done with SQL, There are too many cross table dependencies . You would require both NDA level knowledge and a lot of experience to do it.
I did write a script to populate a database for one of our customers.
I will ask management if that work is proprietary for the customer given it was never used.
Thanks for the response! I thought it was worth the ask. My interest in this query was due to my career (retired programmer with a lot of sql experience in the IBM world). I was hoping that it would be somewhat simple and as long as the media type and path to the data was supplied I thought that maybe once that row was written triggers would take over and do the rest.
And speaking as a retired programmer please accept my kudos to you and your teammates. I think Plex is a wonderful product. I find it to be a robust, solid piece of software which out of the box just works. It’s rare to see software with this consistency across platforms and releases especially for free (but I do have and appreciate how easy it is to justify a lifetime plex pass). Keep up the good work! Oh and maybe Plex should by Tivo. They’ve really gone downhill in the last few years and could use a good re-engineering. Thanks again!!
