Gentoo Archives: gentoo-user

From: Jack <ostroffjh@×××××××××××××××××.net>
To: gentoo-user@l.g.o
Subject: Re: [gentoo-user] Video database software
Date: Mon, 28 Jan 2019 23:13:54
Message-Id: UNAPDLTA.QQIXIDXS.HH57S3AN@I2KK7CXE.IYR2NK7E.VLXH3HTK
In Reply to: [gentoo-user] Video database software by Dale
1 On 2019.01.28 17:54, Dale wrote:
2 > Howdy,
3 >
4 > As some know, I've accumulated a lot of videos.  I googled around and
5 > found some software but not sure based on what they claim if they will
6 > do something I'm looking for.  I installed a couple but not real big
7 > on
8 > how they work.  One requires me to add videos, one at a time.  I have
9 > over 20,000 videos now.  Some are short youtube type videos, some are
10 > long videos.  It could take me years to add them all doing it one at a
11 > time.  Needless to say, that one didn't last long.  The biggest thing
12 > I'm looking for, software that can tell me what videos have a low
13 > resolution.  As a example, some videos I downloaded a long time ago
14 > have
15 > been updated to have higher resolutions.  I may have one that is a
16 > 360P,
17 > or even less, but I may can locate a new version that is HD or even
18 > very
19 > HD.  I'd like software that will tell me this sort of info as well as
20 > other nifty features as well.  Obviously, I'd like to start with the
21 > lower resolution videos first.
22 >
23 > So far, I have installed Griffith and GCStar.  I been googling for
24 > others but some either are not in the tree or I already know they
25 > won't
26 > do one thing I'd like to see.  I'd also like to be able to point it
27 > to a
28 > directory and let it build the database on its own.  Adding them one
29 > at
30 > a time manually just isn't feasible at all. 
31 >
32 > Does anyone know of a software package that will sort a lot of videos
33 > by
34 > resolution as well as track other things as well?  It could be that
35 > what
36 > I'd like to have doesn't exist at all.  Then again, maybe I just
37 > haven't
38 > found it yet.  ;-)
39 >
40 > Thanks.
41 >
42 > Dale
43 Hi Dale,
44
45 I don't know about any such program. I use f-spot for managing my
46 still photos, and it does deal with videos, although I don't know if it
47 would easily allow searching/sorting by things like resolution. Even
48 worse, it is not packaged anywhere I know of, and compiling yourself
49 (it's a dotnet project) is not easy, if even possible.
50
51 However, as I understand it, you want to create a list/database of all
52 your videos, with all or some subset of available metadata, such as
53 resolution. Have you looked whether media-libs/exiftool extracts the
54 data you need? If so, it shouldn't be too hard to craft a tool (I
55 happen to be a Perl bigot, but any similar language should be
56 reasonably close in the required effort) to either put that info into a
57 database (sqlite, mysql, mariadb, postgresql, ....) or even just a
58 single line per video which could be read into a spreadsheet or
59 libreoffice base file.
60
61 Jack

Replies

Subject Author
Re: [gentoo-user] Video database software Dale <rdalek1967@×××××.com>