I suspect mythtv implements a solution that I may use in another project. If I am correct I will dig in the code and find out how it is exactly done. But it would be good to get confirmation that my suspicion is correct.
I assume that mythtv uses the mysql database to store the metadata pointing to the video files (and of course other stuff). I assume the files themselves are not in mysql, instead their name (and location if several storage locations are used). Is that so?
How are the files transported from the backend to the frontend for display? What protocol is used and where should I look in the code?
I would like to implement a solution to an archive that hosts mid-to-large files. I thought I would put only the metadata in mysql and the files themselves will be accessed once their location is looked up in the database (together with some other attributes). The files should be possible to be processed in a streaming manner without downloading them just like for video files. (This is JSON data compressed.) Will I get some useful ideas browsing the mythtv code?