Re: [gentoo-user] Video database software

[Dale]

Mick wrote:
> On Tuesday, 29 January 2019 02:55:02 GMT Dale wrote:
>> Andrew Udvare wrote:
>>>> On 2019-01-28, at 17:54, Dale <rdalek1967@×××××.com> wrote:
>>>>
>>>> So far, I have installed Griffith and GCStar.  I been googling for
>>>> others but some either are not in the tree or I already know they won't
>>>> do one thing I'd like to see.  I'd also like to be able to point it to a
>>>> directory and let it build the database on its own.  Adding them one at
>>>> a time manually just isn't feasible at all.
>>> Seems like you could import via command line?
>>> http://wiki.gcstar.org/en/execution
>>>
>>> You can build the database you need locally with something like exiftool
>>> or MediaInfo, or even ffmpeg https://stackoverflow.com/a/8191228/374110 .
>>> I highly doubt anyone with serious collections is building their database
>>> one item at a time.>
>>>> Does anyone know of a software package that will sort a lot of videos by
>>>> resolution as well as track other things as well?  It could be that what
>>>> I'd like to have doesn't exist at all.  Then again, maybe I just haven't
>>>> found it yet.  ;-)
>>> The closest thing I can think of is Kodi since it's scanner will retrieve
>>> all this information and store it in a straightforward database format.
>>> You can choose SQLite or MySQL (of course MySQL is definitely the better
>>> choice for larger collections). The downside is the scanner is very slow,
>>> especially over a network (and not optimised). The only viewer for this
>>> data (at the time being) is Kodi itself.
>> Not ignoring.  Just pondering this one.  May take some time for me to
>> test some stuff here.  ;-)
>>
>> Thanks much.
>>
>> Dale
>>
>> :-)  :-)
> Installing and having to maintain Kodi just to manage a list of videos is
> probably inefficient - unless you have a regular use for other Kodi
> functionality.  I use it mostly for audio and also the odd video.  It has
> loads of useful plugins to play with.


I see the point but wouldn't mind having some software that I could use
to search for other things as well.  As I mentioned, I have thousands of
videos.  While I have some organized and easy enough to find, I have a
lot of them that I wish I could do keyword searches on.  Just as a
example.  If I'm about to work on my washing machine, I could search for
washing machine and find any videos I have on my washing machine, or
washing machines in general for that matter. I mention that because my
little twisty thingy in the middle isn't twisting anymore.  They claim
there is a ratcheting like thing in there that needs replacing.  ;-) 
I've got to find out how to get to it, what to order etc etc before
tearing it apart.  Videos help with that if one can find it among the
thousands I have.  o_O


>
> If Kodi is of no use, or you prefer a more portable stand alone CLI solution,
> you could look into some basic bash scripts. I couldn't code my way out of a
> paper bag, but here's two basic ideas to get you started.  First to list all
> the videos into a csv file:
>
> find . -xtype f -iname '*.mp4' -o -iname '*.avi' -o -iname '*.mkv' >
> video_list.csv
>
> You may have to add other types of video file containers depending on your
> video collection.  As a second step, in order to list all the video
> resolutions you could pass the find output to xargs:
>
> find . -xtype f -iname '*.mp4' -o -iname '*.avi' -o -iname '*.mkv' | tee
> video_list.csv | xargs -d '\n' exiftool -T -ImageSize
>
> Given my non-existent coding skills I am not sure how to append the output of
> xargs as a second column to the video_list.csv, which you could thereafter
> open with localc to do your searches, or manipulate further.  Of course,
> localc is not necessary.  You can always use less or grep to search the csv
> file very efficiently and also re-create it quickly when you add/delete to
> your videos.
>
> Other more knowledgeable contributors should be able to polish and complete
> the above, or indeed propose something different than bash (python?) to
> perform the same task.
>
> HTH.


Even your command line knowledge surpasses mine by a large margin.  I've
got "&", "&&", and the "|" pretty well figured out.  I use grep but
based on how others use it, I'm doing it the wrong way as well, or at
least the harder/longer way.  I read about that tee command once years
ago.  If my Mom ever gets better and I have some free time, I'm going to
find a howto for complete idiots, so I can start from scratch which is
where I am, at best.  ROFL  My age isn't helping this much.  Sort of
getting to be a old dog.  :/

I'm saving this and will try to analyze it as I can.  I spent most of
the day rounding up meds for my Mom.  Doctor in one town, pharmacy in
another plus waiting. 

Thanks much.

Dale

:-)  :-)