I have a huge collection of files (movies, music, etc) on an external SSD. I wanted to build some kind of local website at the root of that SSD, which could let me create a custom playlist with whatever I decide to filter my files with.
Let's say I want to make a trip-hop playlist, I could filter files with the tag "triphop", then click on a button (presumably, launching some kind of script I would also have to write, but one thing at a time) that would create a playlist file I could open with VLC (again, examples here).
But before I create this script, I would have to create some kind of database that would contain every file, their respective paths, tags (such as "music", "triphop"), etc. I would also consider creating some kind of a "post" page for each file, with either album art or thumbnail of the file, date of creation, etc., well all the info I would ever want to store and display.
I understand that for this, after a few hours of web searching, it seems that a SQLite DB would be most adequate (locally stored file, no need for a server per se), and I'm also leaning towards a local install of WordPress for the handling of posts and tags, but there might be other/better suited/easier options for this. After all, this would be hosted on the SSD, and not meant to be used online (i.e. not on the internet). This would also mean that the machine to which I plug my SSD (let's say, during movie night at a friend's) wouldn't necessarily have PHP installed, or other third-party software. This project would have to be self-contained on the SSD, possibly lightly (so that there is still room left for the files it's meant to store).
I'm wondering what would be the best-suited option, in your respective opinions, for my little evening project?
I'm not afraid of the time it would take to undertake this kind of project, but since I don't want it to last forever, I'm kind of looking for a little help to be efficient and not waste time on unviable options.
What I've tried: Just a reminder, as said above, I've looked into SQLite and local installs of WP, but still not sure it would be self-contained in the end (e.g., using MAMP to run the WP, which wouldn't be installed on other computers than mine).