Groups | Search | Server Info | Keyboard shortcuts | Login | Register
Groups > comp.os.linux.misc > #69201
| From | Eli the Bearded <*@eli.users.panix.com> |
|---|---|
| Newsgroups | comp.os.linux.misc |
| Subject | Re: Program to dole out jpg's to subdirctories, card-dealing style. |
| Date | 2025-06-30 05:53 +0000 |
| Organization | Some absurd concept |
| Message-ID | <eli$2506300151@qaz.wtf> (permalink) |
| References | <103a6c8@dont-email.me> <38h7jlxaom.ln2@Telcontar.valinor> <eli506291631@qaz.wtf> <43944360cb7c4b15fb52908272e9ab34@msgid.frell.theremailer.net> |
In comp.os.linux.misc,
Fritz Wuehler <fritz@spamexpire-202506.rodent.frell.theremailer.net> wrote:
> Eli the Bearded <*@eli.users.panix.com> [EtB]:
> EtB> What I would really like is compound searching.
> Does your program add its photo tags/dates to a database (e.g. sqlite)?
> Can you query its database with other (generic) tools?
My program uses mysql. But (a) I'm not great at writing sql and (b) one
of the largest pain points is loading data into it.
With great work I came up with a tool that builds queries, but not
all the ones I might want. Nor am I impressed with the speed I get.
Example:
$ find-image --debug --tag dog --tag monterey --after 2004:10 --before 2004:12
SELECT a.* FROM `ark_images` a
INNER JOIN `ark_images_tags` i ON i.`image_id` = a.`image_id`
INNER JOIN `ark_tags` t ON t.`tag_id` = i.`tag_id`
WHERE t.`tag_clean` = ?
AND a.`image_id` IN (
SELECT DISTINCT a.`image_id` FROM `ark_images` a
INNER JOIN `ark_images_tags` i ON i.`image_id` = a.`image_id`
INNER JOIN `ark_tags` t ON t.`tag_id` = i.`tag_id`
WHERE t.`tag_clean` = ?
)
AND a.`image_date` > ?
AND a.`image_date` < ?
LIMIT 50;
Binding params: dog, monterey, 2004:10, 2004:12
$ find-image --help
find-image general options:
--newer / -N sort newer first
--older / -O sort older first
--random / -R random order results
--limit / -L smaller sample size
Searching optins:
--anywhere TEXT / -A TEXT description or title or tag
or filename like %TEXT%
--tag TEXT / -t TEXT and clean tag TEXT
--ortag TEXT / -o TEXT or clean tag TEXT
--taglike TEXT / -l TEXT and clean tag like %TEXT%
--nottag TEXT / -n TEXT does not have tag TEXT
--title TEXT / -T TEXT and with TEXT in title
--description TEXT / -d TEXT and with TEXT in description
--filename TEXT / -f TEXT and with TEXT in filename
--after DATETIME / -a DATETIME after 'YYYY:MM:DD HH:MM:SS'
--before DATETIME / -b DATETIME before 'YYYY:MM:DD HH:MM:SS'
DATETIME can be shortened to YYYY, or YYYY:MM, etc
$
I've mapped camera name and location (using long-lat to name database)
to special "tags", but it's not as useful as I hoped, at least for
location: eg:
Title: IMG_3916
image_id: 30347 image_path: /flickr/95/06/3516049506.jpg
image_name: 3516049506 image_date: 2009-03-29 13:47:24
Tags: _county_ San Mateo; _locality_ Pescadero; _country_ United States;
_device_ Canon PowerShot SD870 IS; family; IMG_3916; dog; bo; beach;
bean hollow; 3916; _state_ California; california
"Pescadero" is a fine as that goes, but "bean hollow" beach is a much
smaller area.
There's a (password protected) web ui, too, but it needs even more polish.
Elijah
------
stopped working on it sometime in 2023
Back to comp.os.linux.misc | Previous | Next — Previous in thread | Next in thread | Find similar
Program to dole out jpg's to subdirctories, card-dealing style. pH <wNOSPAMp@gmail.org> - 2025-06-23 00:16 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Robert Heller <heller@deepsoft.com> - 2025-06-23 00:34 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. pH <wNOSPAMp@gmail.org> - 2025-06-23 00:39 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2025-06-23 01:31 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2025-06-23 01:38 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. rbowman <bowman@montana.com> - 2025-06-23 06:00 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. pH <wNOSPAMp@gmail.org> - 2025-06-24 02:39 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Robert Heller <heller@deepsoft.com> - 2025-06-23 02:40 +0000
Re: Program to dole out jpg's to subdirectories, card-dealing style. Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-06-23 03:19 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Dan Espen <dan1espen@gmail.com> - 2025-07-14 16:57 -0400
Re: Program to dole out jpg's to subdirctories, card-dealing style. Marc Haber <mh+usenetspam1118@zugschl.us> - 2025-07-15 07:48 +0200
Re: Program to dole out jpg's to subdirctories, card-dealing style. Nuno Silva <nunojsilva@invalid.invalid> - 2025-07-15 08:35 +0100
Re: Program to dole out jpg's to subdirctories, card-dealing style. Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-07-15 07:44 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Borax Man <boraxman@geidiprime.nospam> - 2025-07-16 10:46 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Richard Kettlewell <invalid@invalid.invalid> - 2025-07-15 11:47 +0100
Re: Program to dole out jpg's to subdirctories, card-dealing style. Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-07-16 04:27 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. jayjwa <jayjwa@atr2.ath.cx.invalid> - 2025-07-15 10:24 -0400
Re: Program to dole out jpg's to subdirctories, card-dealing style. Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2025-07-15 16:35 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. John McCue <jmclnx@gmail.com.invalid> - 2025-07-15 19:32 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Eli the Bearded <*@eli.users.panix.com> - 2025-07-15 23:25 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-07-16 04:29 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Eli the Bearded <*@eli.users.panix.com> - 2025-07-16 06:18 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Robert Riches <spamtrap42@jacob21819.net> - 2025-07-16 03:04 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. candycanearter07 <candycanearter07@candycanearter07.nomail.afraid> - 2025-07-15 19:10 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2025-07-15 22:33 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. candycanearter07 <candycanearter07@candycanearter07.nomail.afraid> - 2025-07-16 17:20 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-07-16 04:27 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. "Carlos E.R." <robin_listas@es.invalid> - 2025-07-16 11:19 +0200
Re: Program to dole out jpg's to subdirctories, card-dealing style. Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2025-07-16 15:53 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. candycanearter07 <candycanearter07@candycanearter07.nomail.afraid> - 2025-07-16 19:20 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Borax Man <boraxman@geidiprime.nospam> - 2025-07-16 10:38 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-06-23 02:22 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. pH <wNOSPAMp@gmail.org> - 2025-06-24 02:42 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Eli the Bearded <*@eli.users.panix.com> - 2025-06-23 04:03 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. pH <wNOSPAMp@gmail.org> - 2025-06-24 02:45 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Rich <rich@example.invalid> - 2025-06-24 04:25 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Eli the Bearded <*@eli.users.panix.com> - 2025-06-24 06:37 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-06-24 06:55 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. c186282 <c186282@nnada.net> - 2025-06-23 01:05 -0400
Re: Program to dole out jpg's to subdirctories, card-dealing style. Richard Kettlewell <invalid@invalid.invalid> - 2025-06-23 08:23 +0100
Re: Program to dole out jpg's to subdirctories, card-dealing style. pH <wNOSPAMp@gmail.org> - 2025-06-24 02:47 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-06-24 03:16 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2025-06-24 04:52 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. c186282 <c186282@nnada.net> - 2025-06-24 01:28 -0400
Re: Program to dole out jpg's to subdirctories, card-dealing style. Rich <rich@example.invalid> - 2025-06-24 20:38 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. rbowman <bowman@montana.com> - 2025-06-24 21:37 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Rich <rich@example.invalid> - 2025-06-27 19:46 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. c186282 <c186282@nnada.net> - 2025-06-25 02:14 -0400
Re: Program to dole out jpg's to subdirctories, card-dealing style. Rich <rich@example.invalid> - 2025-06-27 19:49 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. c186282 <c186282@nnada.net> - 2025-06-27 18:34 -0400
Re: Program to dole out jpg's to subdirctories, card-dealing style. Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2025-06-28 14:07 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-06-28 23:06 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Eli the Bearded <*@eli.users.panix.com> - 2025-06-29 03:41 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-06-29 04:44 +0000
XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) Nuno Silva <nunojsilva@invalid.invalid> - 2025-06-29 10:35 +0100
Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-06-29 23:58 +0000
Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) Eli the Bearded <*@eli.users.panix.com> - 2025-06-30 05:18 +0000
Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-06-30 06:52 +0000
Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) Eli the Bearded <*@eli.users.panix.com> - 2025-06-30 18:50 +0000
Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) John Ames <commodorejohn@gmail.com> - 2025-06-30 13:15 -0700
Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-07-01 00:30 +0000
Re: XDG and Freedesktop Richard Kettlewell <invalid@invalid.invalid> - 2025-07-01 08:38 +0100
Re: XDG and Freedesktop John Ames <commodorejohn@gmail.com> - 2025-07-01 12:49 -0700
Re: XDG and Freedesktop Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-07-01 23:57 +0000
Re: XDG and Freedesktop Nuno Silva <nunojsilva@invalid.invalid> - 2025-07-02 09:33 +0100
Re: XDG and Freedesktop Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-07-02 23:41 +0000
Re: XDG and Freedesktop John Ames <commodorejohn@gmail.com> - 2025-07-03 07:55 -0700
Re: XDG and Freedesktop The Natural Philosopher <tnp@invalid.invalid> - 2025-07-03 16:37 +0100
Re: XDG and Freedesktop John Ames <commodorejohn@gmail.com> - 2025-07-03 08:53 -0700
Re: XDG and Freedesktop The Natural Philosopher <tnp@invalid.invalid> - 2025-07-02 09:27 +0100
Re: XDG and Freedesktop Bobbie Sellers <bliss-sf4ever@dslextreme.com> - 2025-06-30 16:14 -0700
Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-07-01 00:29 +0000
Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) Eli the Bearded <*@eli.users.panix.com> - 2025-07-01 03:40 +0000
Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-07-01 04:28 +0000
Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) John Ames <commodorejohn@gmail.com> - 2025-07-01 09:01 -0700
Re: XDG and Freedesktop Bobbie Sellers <bliss-sf4ever@dslextreme.com> - 2025-07-01 09:10 -0700
Re: XDG and Freedesktop Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-07-01 23:57 +0000
Re: XDG and Freedesktop Nuno Silva <nunojsilva@invalid.invalid> - 2025-07-01 00:07 +0100
Re: XDG and Freedesktop Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-07-01 00:33 +0000
Re: XDG and Freedesktop Nuno Silva <nunojsilva@invalid.invalid> - 2025-07-01 07:02 +0100
Re: XDG and Freedesktop Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-07-01 07:30 +0000
Re: XDG and Freedesktop Rich <rich@example.invalid> - 2025-07-01 13:36 +0000
Re: XDG and Freedesktop (was: Re: Program to dole out jpg's to subdirctories, card-dealing style.) Harold Stevens <wookie@aspen.localdomain> - 2025-06-30 04:00 -0500
Re: XDG and Freedesktop Nuno Silva <nunojsilva@invalid.invalid> - 2025-07-01 00:12 +0100
Re: XDG and Freedesktop Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-07-01 00:21 +0000
Re: XDG and Freedesktop Eli the Bearded <*@eli.users.panix.com> - 2025-07-01 04:20 +0000
Re: XDG and Freedesktop Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-07-01 04:25 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. candycanearter07 <candycanearter07@candycanearter07.nomail.afraid> - 2025-07-01 17:00 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Eli the Bearded <*@eli.users.panix.com> - 2025-07-01 19:29 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. candycanearter07 <candycanearter07@candycanearter07.nomail.afraid> - 2025-07-02 18:20 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Eli the Bearded <*@eli.users.panix.com> - 2025-07-03 16:18 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. c186282 <c186282@nnada.net> - 2025-06-24 01:13 -0400
Re: Program to dole out jpg's to subdirctories, card-dealing style. rbowman <bowman@montana.com> - 2025-06-24 06:42 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. c186282 <c186282@nnada.net> - 2025-06-24 03:42 -0400
Re: Program to dole out jpg's to subdirctories, card-dealing style. rbowman <bowman@montana.com> - 2025-06-24 19:16 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. "Carlos E.R." <robin_listas@es.invalid> - 2025-06-29 12:30 +0200
Re: Program to dole out jpg's to subdirctories, card-dealing style. Eli the Bearded <*@eli.users.panix.com> - 2025-06-29 20:31 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. The Natural Philosopher <tnp@invalid.invalid> - 2025-06-30 08:40 +0100
Re: Program to dole out jpg's to subdirctories, card-dealing style. "Carlos E.R." <robin_listas@es.invalid> - 2025-06-30 14:03 +0200
Re: Program to dole out jpg's to subdirctories, card-dealing style. Fritz Wuehler <fritz@spamexpire-202506.rodent.frell.theremailer.net> - 2025-06-30 02:17 +0200
Re: Program to dole out jpg's to subdirctories, card-dealing style. Eli the Bearded <*@eli.users.panix.com> - 2025-06-30 05:53 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-06-30 06:55 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. c186282 <c186282@nnada.net> - 2025-06-30 02:05 -0400
Re: Program to dole out jpg's to subdirctories, card-dealing style. Eli the Bearded <*@eli.users.panix.com> - 2025-06-30 20:32 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-07-01 00:34 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Charlie Gibbs <cgibbs@kltpzyxm.invalid> - 2025-07-01 11:45 +0000
Re: Program to dole out jpg's to subdirctories, card-dealing style. Shadow <Sh@dow.br> - 2025-06-27 17:57 -0300
csiph-web