Re: [gentoo-user] Video database software

[Dale]

Jack wrote:
> On 2019.01.28 17:54, Dale wrote:
>> Howdy,
>>
>> As some know, I've accumulated a lot of videos.  I googled around and
>> found some software but not sure based on what they claim if they will
>> do something I'm looking for.  I installed a couple but not real big on
>> how they work.  One requires me to add videos, one at a time.  I have
>> over 20,000 videos now.  Some are short youtube type videos, some are
>> long videos.  It could take me years to add them all doing it one at a
>> time.  Needless to say, that one didn't last long.  The biggest thing
>> I'm looking for, software that can tell me what videos have a low
>> resolution.  As a example, some videos I downloaded a long time ago have
>> been updated to have higher resolutions.  I may have one that is a 360P,
>> or even less, but I may can locate a new version that is HD or even very
>> HD.  I'd like software that will tell me this sort of info as well as
>> other nifty features as well.  Obviously, I'd like to start with the
>> lower resolution videos first.
>>
>> 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. 
>>
>> 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.  ;-)
>>
>> Thanks.
>>
>> Dale
> Hi Dale,
>
> I don't know about any such program.  I use f-spot for managing my
> still photos, and it does deal with videos, although I don't know if
> it would easily allow searching/sorting by things like resolution. 
> Even worse, it is not packaged anywhere I know of, and compiling
> yourself (it's a dotnet project) is not easy, if even possible.
>
> However, as I understand it, you want to create a list/database of all
> your videos, with all or some subset of available metadata, such as
> resolution.  Have you looked whether media-libs/exiftool extracts the
> data you need?  If so, it shouldn't be too hard to craft a tool (I
> happen to be a Perl bigot, but any similar language should be
> reasonably close in the required effort) to either put that info into
> a database (sqlite, mysql, mariadb, postgresql, ....) or even just a
> single line per video which could be read into a spreadsheet or
> libreoffice base file.
>
> Jack
>


I do currently use exiftool to get the resolution.  One, it is accurate
and true every time.  I've never had it be wrong.  I do it this way: 
exiftool <path to file > | grep size   Thing is, my scripting is basic
and that is overrating my skills.  lol  Generally, my scripting skills
consists of taking commands I use on the command line and putting them
in a text file and making it executable.  Trust me, if my life depended
on writing a true script, I'm a dead duck.  :/ 

I use digkam to manage my camera pictures and the pictures from my deer
cameras. It also will do videos from the trail cameras set to take
videos instead of pics but it seems very basic on videos.  I don't think
it even does a thumbnail for videos.  I wish it would do what I want and
I could just have one database for my camera type stuff and one for my
other video type stuff.  It also just required me to point it to the
directory with my pics when I started using it and it built its database
in just a few minutes.  One could wish but unless I'm missing something,
it doesn't do what I need with videos.  I'll look into f-spot tho.  It
may work well for my camera stuff too.  Who knows.  What package does
that come with?  I can't find a f-spot here.  Eix didn't help either. 

Thanks for the idea. 

Dale

:-)  :-)