Hi all, new kid on the block here :). I am an amature en audio/video enthusiast. I recently found a solution for creating dynamic mp3 playlists, based on rules. Beats creating music playlists by hand, and use them in a radio software (RadioDJ) as my personal jukebox. This way I can listen my music on any device both at home and away (online).

I also have a Home Theatre Media Server (Plex) that handles my video files and streams to anything you throw media at. Including my radio channel.

I want to do the same with my music videos. The first challenge is how to create dynamic playlists as I do for my mp3 files. MP3 files have heaps of media tags that I can use to filter from. Video files are more difficult the handle and to get the same efficiency. And for my use (you could call it a 24/7 non-stop music channel) I see no point in creating manual playlists.

This got me thinking... My on-the-fly generated mp3 playlists are stored in mySQL. If I could run a procedure that imports the current mp3 playlist, replace the text ".mp3" with ".mp4" I should be able to produce a playlist based on the rules in my radio software.

How does vMix handle working with mySQL databases? Are there other solutions out there that could generate rule-based dynamic video playlists?

You can load a folder/files into playlist in VLC and then save playlist file as M3U or M3U8.
Then add playlist input to vMix that points to your newly created playlist from VLC.

connect to the mysql database and generate output as XML via PHP for example then you can load the xml data into Vmix Datasources