Image management without databases

Originally posted at https://www.robertjelenic.com/image-management-without-databases

This blog post shares the experience of organizing my photos. It’s one of those things I was dreading but I’m very happy with the result. There were a few things I wanted to get right in my setup.

  1. Portability — The entire setup below avoids platform lock-in as much as possible
  2. Flexibility — I want my photos to work for me, not the other way around. I want the freedom to organize my photos as I see fit today and change that easily in the future if need be
  3. Automation — As much of the setup should be automated or semi-automated as possible. The point of the exercise is to enjoy your photos, not to create a new chore

Of course, this won’t be the right setup for everyone and I may have missed something. Feel free to leave comments below.

Disclaimer: I have mostly Apple devices and therefore the tool and workflow selection below reflects that. If you use a Windows machine, you’ll have to do some research to find similar tools that work for you.

Storage

Update: Since I published this article, I moved from Dropbox to Sync.com and then from Sync.com to a Network Attached Storage (NAS) solution. I just dragged and dropped my documents each time with no annoying export/import flows.

Continuous upload

This also avoids your phone holding your recent photos without any backup of them, in case you drop your phone in the river, your photos will be safe.

Organizing your files

This led me to decide to organize my photos into date-based groupings using simple folders. To avoid one huge folder of photos, I group into years, and then where appropriate, into events. Here’s an example:

2017 📁│   ...│   2017-11-19 20.37.30.jpg 🏞│   2017-11-19 20.49.59.jpg 🏞│   2017-11-19 20.37.30.jpg 🏞└───2017-12 Christmas 📁|   │   2017-12-25 15.44.51.jpg 🏞│   │   2017-12-25 15.44.55.jpg 🏞│   │   2017-12-25 15.44.56.jpg 🏞│   2017-12-28 13.14.59.jpg 🏞|   ...

The other years look similar. This setup offers the flexibility of grouping photos where necessary and avoiding it when unnecessary.

File naming

I recommend Renamer for macOS. You can drag an entire directory’s files into the edit window and batch rename them to the images’ true creation date (as stored in the Exif metadata). Exif metadata is great data about the device used to create the photo or movie that’s embedded right into the file (eg. creation date, location, camera type, etc…). Exif metadata (and other metadata) is great for organization because it has no dependencies on the photo app or storage you’re using. It’s intrinsic to the file itself. This point will be important when I address Albums and Tags.

Notes

  • If two photos are taken in the same second, they would present the problem of duplicate naming. Renamer automatically appends a number (eg. “-1”, “-2” and so on) to the filenames as necessary
  • Some files may not have Exif data. In that case, try the Date Created or Date Digitized properties. If those don’t work, revert to naming things manually with as many details as you have (eg. You might only know the photo was taken on July 8, 2018, so name it 2018–07–08.jpg, omitting the hour, minute and second)
  • Dropbox names photos according to this convention automatically (YYYY-MM-DD HH.MM.SS) which is one more reason I like the setup: I can use Renamer when I need to but it’s not a regular occurrence

Duplicates

I use PhotoSweeper. With it, you can rapidly analyze an entire directory full of photos and tell PhotoSweeper what constitutes a duplicate (eg. exact and/or approximate image matches). You can rapidly detect the duplicates and settle on the single image you want to keep.

Notes

  • The ability to identify and clean up approximate matches is a great technical feature of PhotoSweeper, because with easy smartphone photography you may end up with lots of similar photos but want to choose to keep only the best one

Tagging

  • People — photos that include a certain person or people
  • Places — photos taken in certain locations
  • Albums — other meaningful groupings that transcend the events-based directory grouping may be useful for you

Earlier I introduced the idea of exploiting the Exif metadata to rename your files. But metadata doesn’t end there. There is also IPTC metadata. I won’t dive into the detail of what IPTC can store, but the part that’s important for tagging is called keyword. Keywords in IPTC are essentially tags; they're comma-separated words that can be used for filtering your photos. You can add as many as you want to any photo and that metadata is saved right in the image file, avoiding dependency on any particular photo management app.

Enter Adobe Bridge

  • It doesn’t require a database — it’s essentially a viewer of files stored on your computer somewhere. Again, this makes this setup platform independent — Adobe Bridge doesn’t care if you’re using Dropbox, OneDrive or anything else and you can change storage platforms without Bridge knowing or caring
  • Unfortunately Bridge can’t look directly into a Dropbox online directory; the photos must be synced to your local hard drive or a network drive
  • You have full access (sometimes overwhelmingly so) to the photo metadata. I really only use the keyword attribute as a tagging system.
  • Important: The available metadata is displayed as possible filters. That means that you don’t need to know which keywords exist in a batch of photos because Adobe Bridge scans them all and offers existing Keywords as filter criteria. This filtering feature extends to other metadata like filetype, camera model, a lots more. Avoid any viewer that can’t offer existing (and only existing) metadata as a filter criteria.
  • You can elegantly handle the nested directory structure I introduced earlier with its Show items from subfolders feature.

Closing thoughts

  • Dropbox’s in-browser view of photos doesn’t support viewing/filtering/editing IPTC metadata and I’m not holding by breath for that after they shut down Carousel. This means that you’ll need to have all the photos you want to view with Adobe Bridge on your physical hard drive or a network drive. I use Dropbox’s Selective Sync, which an increasing number of cloud providers are offering these days, to limit how many photos eat up my hard drive. But ideally I’d offload the storage of the photos to Dropbox and navigate them with the same sophistication Adobe Bridge offers.

This setup works well for me given my devices and my goals. But there are some places I would love to improve it.

Do you have your own thoughts, tips or tricks on how to handle your photos? This topic is a bit of a minefield and I stopped optimizing things when I felt the setup was good enough without being perfect.

Growth Strategist, B2B Marketer, Podcaster, Technology Geek

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store