Author
Topic: SQL - Package - Import media data (Read 2081 times)

attached you'll find a link to a package of scripts and SQL-procedures which I developed to read video, audio and subtitle information from movie files and import these information into PVD with help of the database interface.

Motivation of this package was the current limitations of the mediainfo.dll and ffmpeg bundled with PVD.Unfortunately ffmpeg doesn't read always the correct informations from a movie file (it isn't neither its scope). Also mediainfo.dll (being an older version) doesn't get always the correct info. For various reasons in the end I approached the problem using the database interface.

The package mainly uses SQL-procedures, mediainfo (command line version), awk and some script.It is possible to process a great number of movie files in one run (I tested it with more than thousand files) and update the database.

I don't know whether someone is interested but I wanted to share it anyway. If you are, I invite you to read the included Readme.txt. Additionally all procedures and scripts are well documented.