In the early 2000s, as digital media devices became more common and personal computer storage started evolving, I — like many other people — began storing photos and videos from many different sources: Sony Cybershot cameras, Nokia N95 phones, images downloaded from ICQ and MSN, and many other devices and applications that no longer even exist today.
At that point, organizing media files was still relatively simple because external storage technology was limited. Network-attached storage was expensive and not easily accessible, and most files still lived on internal computer drives.
With the arrival of the iPhone and similar smartphones, the number of media sources increased exponentially. At the same time, external storage devices became much more accessible, which expanded the number of places where files could be stored.
By then, I already had older media stored on internal drives and started moving newer files to external disks. Around the same period, I also started using something that didn’t exist at the beginning of that journey: media library applications. I moved to iPhoto, which introduced yet another place where my media files existed.
Whenever I replaced my MacBook, I created backups of important files, including my iPhoto libraries. The new machine would continue syncing newer media, but the older libraries remained archived exactly as they were at that point in time.
Eventually, I had media files spread across:
· active libraries,
· library backups,
· exported folders,
· external drives,
· NAS devices,
· and later, cloud storage as it became more popular.
At some point, I decided to consolidate and reorganize that growing collection into a single structure. To do that, I exported media from Photos libraries, created a new library from scratch, and started importing both the exported media and the files scattered across multiple directories and storage devices.
It was not a successful experience.
Separating duplicated media from files without geographic metadata quickly became difficult, especially as the archive kept growing over the years.
Last year, I finally decided to perform a complete reorganization of my entire archive, which had grown to 363,575 files distributed across 10 Photos libraries — one of them containing 182 GB and more than 40,000 files, another with 165 GB and nearly 39,000 files — in addition to 247,130 media files spread across 8,861 directories.
What became clear during that process is that storage itself was no longer the main problem.
The files still existed.
The problem was that the archive structure had gradually become fragmented across:
· libraries,
· exports,
· backups,
· duplicate copies,
· disconnected folders,
· and different generations of catalog applications accumulated over more than two decades.
At some point, I realized I was spending less time thinking about storage capacity and started thinking more about structural consistency.
That was the moment when I stopped looking at the problem as simple media organization and started treating it more like a normalization problem.