How to organize my images? Digikam?

Yes and no. Hierarchical tagging and using the hierarchies when exporting is a feature that is new to Darktable 3.0. The manual is unfortunately not updated yet, and I’m not a developer of Darktable. So I had to find out this feature by trial and error. And as far as I understand it you can either use the flattened hierarchical tags as a file name (ie Persons|Family|Greg becomes “Persons,Family,Greg.jpg”) or the subtags under the root tag as file names (ie “Family” or “Greg” in this case).

So if you want to achieve the output you specified you have to

  1. Create ONE FIXED root tag for each type of export. E.g. ExportTags or “ExportsByPerson” etc.
  2. Create subtags to that root tag. Eg. ExportTags|Persons|Greg
  3. Specify the supertags in your export path. In your case it would be “All JPGs/ExportsTags/dollarsign(CATEGORY0(ExportTags))/dollar-sign(EXIF_YEAR)-dollar-sign(EXIF_MONTH)-dollar-sign(EXIF_DAY)-dollar-sign(TITLE)”. The file ending is added automatically. Replace “dollar-sign” with the actual dollar-sign (this forum translates dollar-signs into LaTeX markup).

If you need to export to more than one root directory you can create export presets, one for each root directory

Hmm…I’ll wait for the manual, and then do trial and error. Anyway all this can wait, as I still have to properly learn to edit my photos :grin:

I recommend thinking carefully about how to organize your photos, because once you’ve chosen a particular workflow/system it can be painful to reorganize your photos according to another system.

Speaking from personal experience here…

1 Like

Doh! I started Digikam before WinNMP (with mariaDB etc.) I had to delete the digikamrc file to get Digikam starting again. It took a few attempts, be careful!

How, exactly, are you using MariaDB?

I use Windows 10
I installed WinNMP in same PC (it domes with MariaDB, HeidiSQL, nginx etc)
In Digikam I chose “DB from external source”

In HeidiSQL you need to create a user/password to be used by Digikam. Test if it can connect, and the rest is automatic.

Was that your question?

1 Like

Just a question: Anybody using NAS storage with Digikam?

I got a Synology DS216 via LAN, it has MariaDB 10.*, so I can put the DB on the NAS. I just wonder what sort of speed I will get out of it? DS216 has just 512Mb RAM and is rather sluggish.

And I wonder how much speed I get via the internet (remote access)

I could get a DS718+ (has 2Gb RAM and can be upgraded).

512mb of ram seems a bit slim to run mysql and the whole operating system.

512Mb (soldered, of course) is quite typical for home use NAS. I have one as file server in the office and it’s fast enough for that. But for i.e. phpMyAdmin, photostation, NextCloud it’s really slow. No fun at all.

And my home DS212j NAS has a modest 256Mb

I use RPi 3B+ with a USB drive as a network storage over SMB. It is slow but okay for still images. I often copy them on a local machine, then cull, organize, process, etc. and then move them back to my slowmoNAS :slightly_smiling_face:

Would you mind to give more details on that, like OS, how many hard drives connected to the pi, and your workflow?
Thanks in advance

I have a Raspberry Pi 3B+ with the regular Raspbian OS. An external HDD is formatted ext4 and shared to my local network via SMB. I store my family pictures and videos there and access them from either KDE Neon or Windows 10 machines. I organize my media with digiKam, edit selected raws with mainly darktable and sometimes RawTherapee, edit selected videos with kdenlive. I also use GIMP and Krita occasionally.
I hardwired the RPi but the connection is still pretty slow. I wish it had SATA interface not just USB. I think its Ethernet port sits on the USB bus too which is a bottleneck for sure.

I switched to a Banana Pi Pro several years ago because of this. It has a SATA connector and Gigabit network. Today I would probably go for a Raspberry Pi 4, I think they finally separated USB (3) from network (Gigabit), and it also has much more RAM.

Looks like RPi 4 needs active cooling (fan) though.
I am not sure I like that.

Never heard something about that, but I doubt it is a requirement. There are much more powerful machines that are fanless.

Edit: I stand corrected…

https://www.jeffgeerling.com/blog/2019/raspberry-pi-4-might-not-need-fan-anymore
That’s a bummer, I was planning on buying one at some point to replace my server :frowning:

You use a DB on the Pi? What speed you get?

I’m running a fanless mini-itx msi celeron mobo and haven’t had any issues, except a short living hd (it lasted less than one year, but it has been put to some stress). After the hd crash, the mobo rested forgotten for some years, and now I reactivated it with an ssd.

My point is that this mini server is located in a room without air conditioning, and the summer here in Rio is very hot, so as far as I remember, the cpu temperature never went below 70°C, with an average of almost 80° during the hot period.

https://br.msi.com/Motherboard/J1800TI

Would you be willing to share your spreadsheet system. It sounds great, but I’m not experienced enough with spreadsheets to set up search by time, event, etc.

jack

Hi st.raw,

I realize that I’m replying to a post that is almost 2 years old - but your description of your starting point here is identical to mine - except that I have close to 1,000,000 photos I’ve managed to aggregate to a hard drive.

I’m wondering if you would be willing to share how you finally solved your organizational challenges and any lessons you learned while doing so.

I’ve just bought an Asustor NAS and have a 10TB mirrored RAID array set up with 2 1TB SSD’s for caching and dual 2.5Gbe (aggregated) network connections. The NAS itself has a quad-core Celeron processor and 4GB of RAM. I managed to get DigiKam installed in a Docker container running directly on the NAS device and I can access the DigiKam interface from a web browser on any computer on my network… but I’m completely new to DigiKam.

From a MacBook, I first tried Lightroom Classic to scan external hard drives and build a library. I liked that I could configure Lightroom to COPY each photo it found to another location and create a file structure of yyyy/mm as well as rename the photos… But I think I would rather have had them put in a “/yyyy/yyyy-mm/yyyy-mm-dd” - and since I have to import them again into DigiKam - is it possible to have DigiKam copy and rename the files as they’re imported - or should I use lightroom to do that on another computer and then just copy the resulting structure to the NAS?

Please share any other advice you’d care to offer after having gone through this yourself - and especially anything I need to watch out for.

Oh - one other thing… is there any way (from metadata?) to automatically detect that certain images are screenshots rather than photos - and move them to a separate area? Or that a picture is extremely small/low resolution - so to skip it altogether?

And after I have this wonderful library of images assembled, is there any AI software I can run to examine the photos and automatically create tags for what they find in each photo? (ie Trees, Lakes, Cars, People, banana’s, etc…). Kind of like our iPhones already do with photos in our iPhone library…?

Thanks in advance…
Jim

Short answer: I didn’t. I was waiting for Synology Photos which came out middle of 2021 - and it had FAR less functions than the old separate Photo Station and Moments. They want to add functions “later”, but since we have near December 2021 now I believe the time frame will be years.

I may look back into other options (again), Digikam is one. However it seems way over the top and I worry about performance inside the Docker. Another option posted here a short while ago is Photoprism - I like that design more. Seems even more difficult to install. And since it’s new, it has probably a risk of getting stale.

So for now I am sort of stuck with the pathetic Synology Photos. I store my images by year and sometimes some subtopics. However one can simply filter images and tag them. So I am not really concerned about any folder structure.

Now is the Digikam performance on your NAS? From inside and outside your network? Does Digikam has good phone apps? That’s another issue I worry about - to complex phone apps for the average family user.

photoprism (looks nice - see demo - but has essential functions missing, like image rotate/multi image rotate - makes it for me a ‘no no’)